Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Single refresh for Dataflow and Dashboard(report)

Hi Gurus,   I have a Purchase Orders to Payments (P2P) dataset that has data for over 5 years. 1. A dataflow is created to import the above P2P data and is refreshed on a monthly basis. 2. A dash...
dataflow
arvindsingh802's avatar
arvindsingh802
Icon for Community Champion rankCommunity Champion
2 years ago

I belive you alreay implemented incremental refresh in your dataflow, if not please do so, that will help reducing the refresh time drastically
Refresh sequance will be same as first data flow refresh need to be completed and then dataset refresh should trigger
You may use Power Automate or Power BI rest API to enable this functionality
You can refer below for same
https://learn.microsoft.com/en-us/power-query/dataflows/trigger-dataflows-and-power-bi-dataset-sequentially

https://radacad.com/streamline-power-bi-refresh-refresh-dataset-after-a-successful-refresh-of-dataflow