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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors