Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
thebigwhite
Helper II
Helper II

Power 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 

1 ACCEPTED SOLUTION
ibarrau
Super User
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-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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
thebigwhite
Helper II
Helper II

I ll go with Power Automate Solution.

Thanks

ibarrau
Super User
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-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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.