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.
Hi,
I used Power BI Premium's Data Flow to create the report.
In Power BI Desktop, when I selected the dataflow from Get Data, the performance was different when I selected it in import mode and in DirectQuery.
When I used Import, the data could be aggregated in about a minute when I issued it to Service.
When using DirectQuery, the data timed out after about 5 minutes of publishing to Service.
When there was only one table, the performance did not change much, but when two tables were aggregated on the report, the performance of DirectQuery on the data flow did not change much.
The performance of the DirectQuery in the data flow seemed to drop when changing two tables on the report.
Is there any difference in performance between Import and DirectQuery?
If I want performance, should I use Import?
Translated with www.DeepL.com/Translator (free version)
thanks
Solved! Go to Solution.
Hi @koya112929
The difference between Direct query and Import mode is not the Performance.
The choice of what and how you need to connect to your data and then in the service is what makes the difference.
Both modes have their pros and cons and limitations.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @koya112929
The difference between Direct query and Import mode is not the Performance.
The choice of what and how you need to connect to your data and then in the service is what makes the difference.
Both modes have their pros and cons and limitations.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thank you for your quick answer!
I have solved the problem!
I have been able to access the dataflow from Power BI Desktop.
This is also the case for Power BI Premium dataflow.
I imagined that selecting this option would not change the performance of reports published to the Power BI Service, and that both would behave the same as import.
It seems that the data flow also works the same as the traditional import and Directquery.
Thank you very much.
Hi @koya112929
Interested in your question above.
As I am also testing the performance btw direct query and import when using PBI dataflow as the data source.
Do you find the performance is worse when connecting to dataflow in direct query mode? (compare to import mode)
Thanks!
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 |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |