Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All,
I am confused understanding direct query between SQL Database Vs Azure SQL Database Power BI
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-directquery-data-sources/
I am currently using SQL Server
For SQL:
Gateway is required.
Does it mean I cannot have real-time data when using direct query and can only refresh dataset after 15min?
It is mentioned under benefit of using direct query
The 1 GB dataset limitation does not apply to DirectQuery
And limitation is
The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows.
Is the above same for SQL server?
Your prompt response would be highly appreciated.
Solved! Go to Solution.
Hi @mak82pk,
There is no different between SQL DB and Azure SQL DB, it's based on your connection mode (Import mode or Direct Query).
Hi @mak82pk,
There is no different between SQL DB and Azure SQL DB, it's based on your connection mode (Import mode or Direct Query).
Thanks for your prompt response.
I embedded the URL in my web application and report was updated after 1 hour even when I was interacting with the report.