Multiple XML with different refresh hours on one table

[DV]

Hello,

Is it possible to use two XML with different refresh hours for one table?

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. And this data should be on one table, looking user friendly. Thanks

[TeigeGao]

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

[DV]

Hi, @TeigeGao 

Or maybe there's a chance to turn on "enable load" only at specific time? Then on one query it will be turned off at day time, it enables automatically at night - does a refresh and after that turnes off "enable load" again. Cannot think of other possibilities to use two queries (one for a full year) ant the other is only few days. Table should show all information (appends two queries) and if refresh was pressed at day time - it should only update that small query, the bigger one should be refresh only at night to avoid big data load at day time. Maybe you have different solution for this?

[DV]

Maybe you can guide with steps, what actions should be taken for your mentioned workaround?

[DV]

Maybe you can guide with steps, what actions should be taken for your mentioned workaround?