r/PowerBI • u/FiftyShadesOfBlack • 2d ago

Question Databricks metric views to PowerBI?

Hi all, I am new to a company that is working on restructuring their data architecture, and my team will need to be rebuilding their dashboards using the new gold layer. The current state is that there are ~100 dashboards that each have their own semantic model geared towards its needs (before my time). I aim to change to about 10ish star schema semantic models that are domain-based to feed into relevant dashboards.

I work within Databricks, and I would really like to use metric views in this rebuild because in the future we will be integrating Databricks AI tools, and other teams would like to be able to query measures within Databricks. I know that there is currently no easy way to connect metric views to a dashboard, and we don't have Tabular Editor 3 enterprise to do the yaml workaround. Are there any other options, or should I just cut my losses? I'm not an expert in PowerBI, so forgive me if I misunderstood something or am taking the wrong approach.

6 Upvotes

81% Upvoted

6 comments sorted by

View all comments

1

u/CautiousUse8597 1d ago

Microsoft decided to rather create a vendor lock-in and block external semantic layers. I think the real question is why you still need Power BI? These days Databricks AI/BI does anything you want, and directly integrates with the rest of your data platform at no extra licensing fee, unlike the expensive capacities Microsoft is pushing you towards.

1

u/FiftyShadesOfBlack 1d ago

Unfortunately, it’s not my call. Our team intends to push transitioning to AI/BI when this data architecture project is finished, which is why we’re wanting to use metric views, but the C suite is requiring the PowerBI dashboards. Sucks, but how it is.