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.
I have created a report in PBI Desktop with an on-premise SQL Server database as the data source. I have enabled Direct Query (rather than Import), yet changes in the SQL Server database are not being reflected in the report. Are there any common errors related to this problem? Ideally I plan to publish this report to my org's PBI Report Server and have it update (based on changes in the SQL Server database) in as cloes to real-time as possible.
Thanks,
Harrison
Hi @hlewisNYC,
When using Get Data in Power BI Desktop to connect to a data source, and you choose DirectQuery, the behavior of that connection is as follows:
For more details about using DirectQuery in Power BI, you can refer to the following tow article.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Regards
I have created a report in PBI Desktop with an on-premise SQL Server database as the data source. I have enabled Direct Query (rather than Import), yet changes in the SQL Server database are not being reflected in the report while still in PBI Desktop (we are beginning to use Report Server at our org but it seems like RS reports can only use DQ in relation to Analysis Services). Are there any common errors related to this problem?
Thanks,
Harrison
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |