Multiple XML with different refresh hours on one table

Hi DV ,

PowerBI Service refresh time is setup for a dataset rather than a data source, each report can only use one dataset, as a result, if you want to use the XML files in one report, we can't refresh the XML files separately.

---

I want to refresh one XML (full 7 months data) to get full data from server at night and the other XML for every few hours (-2 days and +2 days interval data). I cannot always refresh asking for a full Data because of a server load and I need updates every single hour as information updates every minute. 

---

Maybe we can find other workaround in this scenario, generally, these two data source are used for different-grained. In this scenario, we can handle the coarse-grained data in the data source, then import the result to PowerBI dataset, this may not cause a huge server load.

Best Regards,

Teige