cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Do Databricks SQL Endpoints support PowerBI in DirectQuery mode?

User16826992666
Valued Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

Hubert-Dudek
Esteemed Contributor III

According to: https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi yes. It is standard sql so should be not problem. However when querying this way there can be issues when querying by field which is not used to partitioning or z-order. Personally when model is not extremely big I prefer to load everything to PowerBI and set daily reload. When it is real time data is better to use streaming (Databricks stream sink to Azure event hubs connected to Azure streams which is consumed by PowerBI).

View solution in original post

1 REPLY 1

Hubert-Dudek
Esteemed Contributor III

According to: https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi yes. It is standard sql so should be not problem. However when querying this way there can be issues when querying by field which is not used to partitioning or z-order. Personally when model is not extremely big I prefer to load everything to PowerBI and set daily reload. When it is real time data is better to use streaming (Databricks stream sink to Azure event hubs connected to Azure streams which is consumed by PowerBI).

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group