Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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?
@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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |