cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tracytran
Resolver I
Resolver I

PowerBI.RefreshDataset() does not work

Hi friends, 

 

I am building my very first app which allows PowerBI user able to add/correct data directly on Power BI service by using Power Apps visual provided in Power Bi. 

 

In my case, my source data are the excel file which is hosted on Sharepoint. I was correcting the wrong reject reason from W3 to W3333. After I submitted the form, I checked my original data on the excel file, it updated. However, it did not refresh the visual on Power BI. It still kept W3. 

 

tracytran_1-1636343096544.png

 

I tried using PowerBIIntegration.Refresh() and PowerBI.RefreshDataset() but there was no luck. 

 

tracytran_0-1636342615815.png

 

Could anyone please help me regarding this issue? 

 

Thank you for your support. 

14 REPLIES 14
StalinPonnusamy
Super User
Super User

Hi @tracytran 

 

Once the above post is completed then remove the button and update the code 

 

Notify("Successful")
Set(
    ReturnString,
    ResetPowerBIDataset.Run().returnvaluestring
);

 

Insert a label and set the text property to

ReturnString

 

This verifies the power automate completed or not

Note: Return type updated from boolean to string.


Thanks,
Stalin - Learn To Illuminate

@ thank for your solution. 

It works like a charm!!! 

 

StalinPonnusamy
Super User
Super User

Great to hear.

Hi All,

I actually have a similar issue here although my problem is that the dataset in my Power BI workspace won't update. Here is the link to my question:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Why-does-my-Power-BI-dataset-not-refresh-whe...

I'd greatly appreciate it if anyone could help me on this. 

I watched the video, I followed the steps multiple times but unfortunately I just can't seem to get it to work. Furthermore, I get an error when I use PowerBI.RefreshDataSet. I'm just wondering whether you can help me. Here is a link to my question:

https://powerusers.microsoft.com/t5/Building-Power-Apps/RefreshDataSet-is-an-unknown-or-unsupported-...

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,627)