Power BI Pipeline

[thebigwhite]

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 

[thebigwhite]

I ll go with Power Automate Solution.

Thanks

[ibarrau · Accepted solution]

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-group

The 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,