Forum Discussion
Helper IIPower BI Pipeline
Hello
I need to refresh dataflows and their related datasets directly using pipelines. Is it possible, and are there any pre-made templates to get inspiration from.
My intention is to manage the schedule of the dataset reload only thorugh Pipeline. Does it make sense?
Thanks
Hi. Sure you can. You can send the request for refresh via API. There are requests like this:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-groupThe problem is controlling when it's over. This sends de requests and that's all. The Power Automate / Logic Apps have a trigger that is "When a dataflow refresh is over". That makes me think there might be a way to know when the dataflow is over.
If you are talking about dataflow gen2 (fabric), then there is an activity for that at the fabric pipelines. The dataset still needs to be a web activity sending a request.
Example using an azure data factory pipeline to refresh a dataset: https://blog.ladataweb.com.ar/post/642023841877671936/azuredatafactory-actualizar-powerbi-con
I hope that helps,
2 Replies
- ibarrau
Super User
Hi. Sure you can. You can send the request for refresh via API. There are requests like this:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-groupThe problem is controlling when it's over. This sends de requests and that's all. The Power Automate / Logic Apps have a trigger that is "When a dataflow refresh is over". That makes me think there might be a way to know when the dataflow is over.
If you are talking about dataflow gen2 (fabric), then there is an activity for that at the fabric pipelines. The dataset still needs to be a web activity sending a request.
Example using an azure data factory pipeline to refresh a dataset: https://blog.ladataweb.com.ar/post/642023841877671936/azuredatafactory-actualizar-powerbi-con
I hope that helps,
thebigwhiteI ll go with Power Automate Solution.
Thanks