Update a Power BI parameter on a dataset using power automate

(0) Share

Report

Posted on by Sumaira

642

Hello Community Experts,

There is a requirement where i have to automate flow to update a Power BI parameter on a datasets

Presently users click Datasets Name>Settings>Parameter>Update and after that to trigger datasets refresh, wait and then go back to the report, the client wants this whole process to be automated.

It should use the credentials of the user that triggered the flow for the above process

How do i achieve this requirement I'm new to power BI

Kindly Advise

Best Regards,

Sumaira Noor

Categories:

Using connectors

I have the same question (1)

All responses (7)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Sumaira,

Unfortunately, Power BI connector in Flow is still in preview step, there are only two actions could do are Add rows to a dataset and Refresh a dataset, so your requirement couldn't satisfied.

https://docs.microsoft.com/en-us/connectors/powerbi/

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Saikamal_K 2 on at

Like (0)

Report
Copy link

Link copied!

Hello @Sumaira ,

I am also looking for the same thing.

As far as i know that feature is not yet available in Power Automate.

Any one can correct me if i am wrong.

If there is already a solution by anyway , kindly let us know, that would be so helpful

Thanks in advance

Was this reply helpful? Yes No
aadhawan 111 on at

Like (3)

Report
Copy link

Link copied!

Is this approach available now, its been 3 years. Did someone find a different solution to this request.

Thanks

Was this reply helpful? Yes No
Beaner 18 on at

Like (1)

Report
Copy link

Link copied!

I'm looking for the same solution. I need to refresh a Power BI dataset that uses data parameters. I need to pass different dates each week. It's a non-foldable query so I cannot use the native Power BI incremental refresh.

Was this reply helpful? Yes No
Axelito1010 4 on at

Like (0)

Report
Copy link

Link copied!

U find any solution ?

Was this reply helpful? Yes No
Axelito1010 4 on at

Like (0)

Report
Copy link

Link copied!

U find any solution?

Was this reply helpful? Yes No
Beaner 18 on at

Like (0)

Report
Copy link

Link copied!

For my purposes, I use the current date to calculate the past Sunday and the Monday three weeks ago to get my start and end dates.

End_Date="& ""&DateMap(Date.AddDays(Date.EndOfWeek(DateTime.LocalNow(),1),-7))&"" &
"&Start_Date=" & ""&DateMap(Date.AddDays(Date.EndOfWeek(DateTime.LocalNow(),1),-34))

Was this reply helpful? Yes No