Forum Discussion
Power BI Dataset understanding
Hello everyone.
What are the main benefits of using Import vs Direct Query mode for PowerBI Datasets?
I have a PowerBI Dataset in DirectQuery mode that is updated each morning. I have two questions about it.
- How does it work? Does it send a request to Databricks and retrieve the information each morning, or what's updated?
- What happens when a developer imports this dataset to be used? Does it send again a refresh request to Databricks?
Thanks
Hi julsr
With Import it imports all the data into the Power BI Service and when a person interacts with the report it uses data within the Power BI Service and does not re-query Databricks.
With DirectQuery each and everytime the user interacts with the report it goes back to the source and runs queries against the Databricks source.
If you pay per query in Databricks and the data is not being updated multiple times a day then with Import it loads data once a day and that is the only query run.
DirectQuery means that users can access the latest data from Databricks.
1 Reply
Hi julsr
With Import it imports all the data into the Power BI Service and when a person interacts with the report it uses data within the Power BI Service and does not re-query Databricks.
With DirectQuery each and everytime the user interacts with the report it goes back to the source and runs queries against the Databricks source.
If you pay per query in Databricks and the data is not being updated multiple times a day then with Import it loads data once a day and that is the only query run.
DirectQuery means that users can access the latest data from Databricks.