Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm using the Desktop version and have imported a number of XML files.
The XML files are updated weekly. Is it possible to link to the source file for real time data?
Solved! Go to Solution.
Hi @Newbie1234 ,
DirectQuery is supported only for SQL databases or when connecting to an existing Power BI dataset through Direct Query. In Power BI Service, you can schedule a dataset refresh (requires Pro license). You may need to you use a Power BI Gateway if your data source is on-premise (not stored in the cloud).
Proud to be a Super User!
Hi @Newbie1234 ,
By realtime you mean the report updates as the data source does? You'll need a streaming dataset or direct query for that.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
Proud to be a Super User!
Thank you. DirectQuery seems to be what I'm looking for, but unfortunately it seems it doesn't support XML files. Just wondering if there's any other way to update the data from the XMLs regularly?
Hi @Newbie1234 ,
DirectQuery is supported only for SQL databases or when connecting to an existing Power BI dataset through Direct Query. In Power BI Service, you can schedule a dataset refresh (requires Pro license). You may need to you use a Power BI Gateway if your data source is on-premise (not stored in the cloud).
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |