refresh queries on different timing

[adnankabina]

I have two sql query coming from different data source then I append them into one data set on Power bi. I want to refresh 1st query to run 1 hour before the 2nd one. ?  schedule refresh run on same time. I want to run 1 query to run 7am then second query to run 8am. Is it possible , both data module in the same file.

[mahoneypat]

If you can publish a Power BI report/dataset, you can also create Dataflows in that same workspace.  You can't selectively refresh queries through a flow (or any way as far as I know).  You need to separate them somehow, and Dataflows would be the simplest way.

Pat

[mahoneypat]

You could turn each query into a Dataflow with separate refresh timing (or just the first query), and then use them/it as your source in your dataset.

Pat

[adnankabina]

Thanks for your reply. I dont have dataflow , I have Powerautomat , will it work there