Unanswered

When a Power BI dataset refresh completes

(0) Share

Report

Posted on by simontaylor305 Microsoft Employee

Hi Experts,

I remember there is one trigger called as "When a Power BI dataset refresh completes". But when I want to create a run a power bi query after a dataset refresh. How can I know when the dataset refresh completes?

Thanks,

Simon

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @simontaylor305 ,

Add email notification action after Refresh a dataset action. Whenever the dataset gets refreshed, you will receive email.
You can create Excel log as well if required.

Hope this will help you.

Regards
Kaif

Was this reply helpful? Yes No
simontaylor305 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you Kaif for your reply.

My purpose for this scenario is:
1. use this trigger to trigger a job to run a DAX try to get some data from a dataset.
2. export the data to csv file
3. use ADF to load those csv file into my DB

But I have to setup a trigger by myself with fixed time. I want to setup a trigger with "When a Power BI dataset refresh completes".

Was this reply helpful? Yes No
simontaylor305 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

By the way, I voted for adding this feature for Power Automate.

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

There is a trigger for PowerBI called "When a data-driven alert is triggered." You can create an event in PowerBI that triggers when the data is updated and use Power Automate to sends the email/add actions.
https://www.thebiccountant.com/2022/10/11/when-a-power-bi-dataset-refresh-completes-trigger-in-power-automate/?utm_source=rss&utm_medium=rss&utm_campaign=when-a-power-bi-dataset-refresh-completes-trigger-in-power-automate

Regards
Kaif

Was this reply helpful? Yes No