Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

PowerBI performance with Azure Databricks

We have integrated PowerBI with Databricks to generate reports. However, PowerBI generates over 8,000 lines of code, including numerous OR clauses, which cannot be modified at this time. This results...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    If you have Premium capacity, consider Config Automatic Aggregations to improve performance.
    Once the model is trained, Power BI will have aggregated values in in-memory cache. The next time you interact with the report using similar patterns (dimensions, measures, filters) Power BI will leverage cached aggregations to serve the queries and will not send queries to Databricks SQL Warehouse.

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Poojara_D12's avatar
Poojara_D12
Super User
1 year ago

Hi Anonymous 

 

  • Use Temporary Views: Create a view in Databricks with the OR conditions applied, and connect Power BI to this view.

  • Replace OR with JOIN: Use a temporary table for filter values and join it with the dataset to replace the OR clause.

  • Enable Dynamic Query Pruning: Ensure spark.sql.optimizer.dynamicPartitionPruning is enabled in Databricks for better performance on large filters.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS