Unanswered

Update PBI dataset from API using Power Automate

(0) Share

Report

Posted on by gasilva8

I'm trying to use scheduled refresh on power bi, but I don't understand why it seems to work randomly. The datasets come from an API, which works fine with PBI Desktop query.

I was told to try doing scheduled refresh by using power automate, but I don't know how to do that since the PBI connector in Power Automate doesn't give that option.

Does anyone have any tip on how to do that?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

mahoneypat 1,720 on at

Like (0)

Report
Copy link

Link copied!

Are you using the Refresh a Dataset action?

Pat

Was this reply helpful? Yes No
gasilva8 64 on at

Like (0)

Report
Copy link

Link copied!

@mahoneypat
Yes, but I guess this is not the right approach. Or not?
I'm trying to create a customized connector. I have 15 datasets with 15 different API URLs.
Should I create a custom connector for each API?

Was this reply helpful? Yes No
mahoneypat 1,720 on at

Like (0)

Report
Copy link

Link copied!

You shouldn't need a custom connector. You can input an array of the dataset values (e.g., Excel table or SharePoint list), and then do an Apply to each step in which you have the Refresh a dataset action with the values from the current iteration of the array.

Pat

Was this reply helpful? Yes No