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 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.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks for your reply. I dont have dataflow , I have Powerautomat , will it work there
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |