PowerBI Tips
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2024 07:13 AM
Does anyone have any tips for using PowerBI on top of databricks? Any best practices you know of or roadblocks you have run into that should be avoided?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2024 12:38 PM
I would recommend you go over the recording of Power BI on Databricks Best Practices (youtube.com) webinar from couple of weeks ago.
On top of that, I would strongly recommend evaluating if you need to go through a PBI Data Gateway for security reasons.
Another suggestion is to really consider using tiered approach and not one-approach-fits-all. For instance - small-data models, that can fit in PBI and do not need complex security - you can do Import mode and use Databricks only during refresh times. For larger models, or data, where you have your data authorization in Databricks (RLS, OLS, masking, etc.), then go for Direct Query.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2024 05:26 AM
Hey,
Use Partner Connect to establish a connection to PBI
Consider to use Databricks SQL Serverless warehouses for the best user experience and performance (see Intelligent Workload Management aka auto-scaling and query queuing, remote result cache, predictive I/O)
Also may be interesting : Scaling Your Workloads with Databricks Serverless (PBI example)
Hope it helps,
Best,

