topic PowerBI Tips in Get Started Discussions

PowerBI Tips

Carpender — Fri, 12 Apr 2024 14:13:38 GMT

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.

Re: PowerBI Tips

Ivan_Donev — Sun, 14 Apr 2024 19:38:59 GMT

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.

Re: PowerBI Tips

artsheiko — Tue, 16 Apr 2024 12:26:57 GMT

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,