Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |