Forum Discussion
Force Power Bi service to execute queries sequentially
How do I force the PowerBI service to execute queries sequentailly? I can do it on the desktop by going into the settings, but nothing I do seems to be able to force the service to execute them sequentailly.
Cheers!
Hi Anonymous
My understanding is that if you make the changes in PBI Desktop it should also be applied in the PBI Service.
Here are more details on how to change those settings: Evaluation configuration settings for Desktop - Power BI | Microsoft DocsHi Anonymous - it is possible to order the refreshes but it depends on your solution. If you are using Dataflows, these can be scheduled to run sequentially using Power Automate.
Dataflow Automation using the Power Query Dataflows Connector in Power Automate | Microsoft Power QueryIf you are talking about refresh individual queries in Dataset, you need to either use an XLMA endpoint, REST API or a Power Automate custom connector.
XMLA-Based PBI Dataset Refresh Automation – Insight Quest (insightsquest.com)
Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Docs
3 Replies
- GilbertQ
Super User
Hi Anonymous
My understanding is that if you make the changes in PBI Desktop it should also be applied in the PBI Service.
Here are more details on how to change those settings: Evaluation configuration settings for Desktop - Power BI | Microsoft Docs Hi Anonymous - it is possible to order the refreshes but it depends on your solution. If you are using Dataflows, these can be scheduled to run sequentially using Power Automate.
Dataflow Automation using the Power Query Dataflows Connector in Power Automate | Microsoft Power QueryIf you are talking about refresh individual queries in Dataset, you need to either use an XLMA endpoint, REST API or a Power Automate custom connector.
XMLA-Based PBI Dataset Refresh Automation – Insight Quest (insightsquest.com)
Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Docs