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

[ogabek]

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?

[amitchandak]

@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

[ogabek]

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!