Data refresh seperaterly

Hi jimpatel ,

I'd group the queries by refresh frequency, then add the least frequent into their own dataflow.

For example, leave the two Excel linked tables in your desktop report, and refresh the report in the PBI Service every hour. Put all the six-hour refresh queries into a dataflow which you refresh every six hours, and bring these queries into your desktop report via dataflows.

Pete

No problem. Dataflows are Power Query queries that are stored in the Power BI Service, and can be connected to from Power BI desktop via Get Data, just like any other source. You can refresh them independently of any reports in order to have your query results in the cloud, ready for when you need them.

Here's MS Intro to Dataflows:

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service 

And here's MS Creating a Dataflow:

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create 

Pete