Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Bring data (direct query mode) to Power BI from Databricks SQL query

I have some tables and a transformation query in databricks. My task is to import databricks` query output to PowerBI in direct query mode.

Why direct?

  • If any table in query is updated, it should affect data on power bi site

I have tried to use direct query in power bi and source as SQL script. But when I update transformation tables in databricks and refresh view in PowerBI, changes didn't show up

Is there any work around to get data from databrick query to PowerBI in nearly real time? At least direct query mode?

Super User
Super User

@ogabek , It should update in direct query mode.  set automatic refresh in desktop . Clear cache of browser in case service refresh and try.  Also, check the mode of the table in the model view under property pane -> Advance -> Make sure it direct

thanks for your reply, but it is not just table i am sql querying databricks database and that output is my source


I mentioned the question here too - Stackoverflow 


Best Regards!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors