PowerBI.RefreshDataset() does not work

[tracytran]

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. 

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

Could anyone please help me regarding this issue? 

Thank you for your support. 

[StalinPonnusamy · Accepted solution]

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

[tracytran]

@ thank for your solution. 

It works like a charm!!! 

[StalinPonnusamy]

Great to hear.

[HamidBee]

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. 

[HamidBee]

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-...

[Ally7]

Hi Stalin, Can you guide me through PowerBI refresh functionality within power App. I'm stuck and I need to submit my assignment. Thank you

[Resh10]

Hi Stalin, 

I used the same method as mentioned by tracytran. I used this formula in my submit button. Eventually, After I submitted the form, I checked my original data on the excel file in SharePoint, its updated. However, it did not refresh the visual on Power BI. However, when I check in my dataset, it prompt refreshing. Although after refresh, the visual in the Power BI did not refresh unless I refresh the dataset manually. 

Need your help on this. Thanks