Forum Discussion
Real Time Dashboard
Hi ShivaPr,
lbendlin clarified the approach, I just add that the automatic page refresh needs at least a Premium Per User licence (or a dedicated Capacity)
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi ShivaPr
Connect Power BI to Databricks - https://youtube.com/playlist?list=PLE_IpfSmEJ83xroWa2oN5RI5qzBnwS5KW&si=YKG20oZZNbgkNbO-
Option 1 - Near Real-Time Report
Best for interactive reports
Architecture
Databricks → SQL Warehouse → Power BI DirectQuery
Steps
In Databricks, expose data via Databricks SQL Warehouse
In Power BI Desktop
>Get Data → Azure Databricks
>Choose DirectQuery
Optimize model
>Star schema
>Fewer columns
>Avoid complex DAX
Publish report
In Power BI Service
>Enable Auto Page Refresh
>Set refresh interval to 30 seconds (minimum allowed)
Limitations
5 seconds
Heavy visuals will slow down
DAX must be simple
Option 2 - True Real-Time (5 seconds) – Dashboard Only
Best for KPIs & monitoring
Architecture
Databricks → Event Stream → Power BI Streaming Dataset → Dashboard
Steps
Push data from Databricks to:
>Azure Event Hub / REST API
Create Streaming Dataset in Power BI Service
Build Dashboard tiles (not reports)
Tiles update every 1–5 seconds
Limitations
No report visuals
No complex modeling
No relationships