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 need to know how Direct Query works for SQL Server? For import mode, I know it clears and adds new records dataset after the configured time (say 15min).
Does Direct Query push records to the dataset or it works like import mode?
Solved! Go to Solution.
@mak82pk,
When using DirectQuery mode to connect to SQL Server database, no data will actually be imported into the Power BI store upon load. Queries will be sent to SQL Server database to retrieve necessary data when building visuals in Power BI Desktop.
After publishing report to Power BI Service, also, no data is included with the dataset. For more details, please review the following article.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-directquery-about/
Regards,
Lydia
@mak82pk,
When using DirectQuery mode to connect to SQL Server database, no data will actually be imported into the Power BI store upon load. Queries will be sent to SQL Server database to retrieve necessary data when building visuals in Power BI Desktop.
After publishing report to Power BI Service, also, no data is included with the dataset. For more details, please review the following article.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-directquery-about/
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 |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |