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 guys
I was wondering:
What's the difference between having a PBI report that is connected to the data (say SQL) via gateway and a DirectQuery created in PBI service to that same SQL data?
cheers
Solved! Go to Solution.
@giro17,
When you connecting to SQL Server data source in Power BI, it requires gateway to refresh the dataset both in import mode and DirectQuery mode.
For import mode, there is 1GB pbix file limitation , and it limits to refresh 8 times a day unless you have Premium license. For DirectQuery mode, there is no such limitations. For other difference, please take a look at the following blog.
http://www.presencecg.com/blog/power-bi-debate-directquery-vs-import/
Regards,
Lydia
@giro17,
When you connecting to SQL Server data source in Power BI, it requires gateway to refresh the dataset both in import mode and DirectQuery mode.
For import mode, there is 1GB pbix file limitation , and it limits to refresh 8 times a day unless you have Premium license. For DirectQuery mode, there is no such limitations. For other difference, please take a look at the following blog.
http://www.presencecg.com/blog/power-bi-debate-directquery-vs-import/
Regards,
Lydia
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |