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'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!
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 |
---|---|
96 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |