PowerBI.RefreshDataset() does not work

(0) Share

Report

Posted on by tracytran

144

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @tracytran

Power BI is connected to excel but through a refresh cycle. PowerBIIntegration.Refresh() will refresh the data but from cached data. There is no way to make automated updates when the data source is excel. Power BI Refresh based on your refresh cycle when the data source is not supporting a direct query.

The only option is to use Direct Query when building Power BI Report. Here is the MS article for supported data sources for direct queries.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
tracytran 144 on at

Like (0)

Report

@StalinPonnusamy I got your point. Thats why I tried using PowerBI.RefreshDataset() to refresh dataset, but does not work.
PowerBIIntegration.Refresh() Will work only with Direct Query.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Hi @tracytran

We need to Reset the Power BI control once the data is updated. Set the OnSuccess property of the form to
Notify("Successful") Set(ResetPowerBI, false); PowerBI.RefreshDataSet("me","Dataset GUID"); Set(ResetPowerBI, true);Set(ResetPowerBI, false);

And Set the Reset property of Power BI Control to
ResetPowerBI

Daniel has a video that discusses specifically this issue. Watch from 11:30 on this video.

I hope this resolves the issue.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @tracytran

I have updated the above post for the steps to refresh.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
tracytran 144 on at

Like (0)

Report

@StalinPonnusamy Thank for your suggestion.

I gave it a try. However, it was the same, not working. It refreshed dataset, not the visual.

My case is a little bit different with Daniel. I integrate Power Apps into Power BI and he integrates Power BI into Power Apps. Therefore, there is no Power BI Control to refresh the property.

I am thinking using Automate in Power Apps to refresh it. I created a flow to refresh Power BI, however, I am new with Power App, I do not know how to trigger a flow in Power App form. Do you have any idea about it?

Was this reply helpful? Yes No
tracytran 144 on at

Like (0)

Report

@StalinPonnusamy Thank for your suggestion.

I gave it a try. However, it was the same, not working. It refreshed dataset, not the visual.
My case is a little bit different with Daniel. I integrate Power Apps into Power BI and he integrates Power BI into Power Apps. Therefore, there is no Power BI Control to refresh the property.
I am thinking using Flow in Power Apps to refresh it. However, I am now with Power App. You have any idea about it?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @tracytran

Then will try to reset Power Bi Dataset using Power Automate.

Create new Power automate
Select Trigger: PowerApps (Like below)

Flow Steps/Actions: (My flow Name : ResetPowerBIDataset)

Call the flow from PowerApps Once the form is submitted successfully

Notify("Successful") ResetPowerBIDataset.Run()

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
tracytran 144 on at

Like (0)

Report

@StalinPonnusamy thank for your prompt reply.

I created the flow as your suggestion:

I Call the flow from PowerApps Once the form is submitted successfully. However, it raised the error.

I tried the second time with Onsuccess action. It also raised the error.

Do you have any idea where I am missing? @StalinPonnusamy

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @tracytran

Looks like the Power Automate is not connected to PowerApps. You may need to close the app and reopen it to connect the newly created Power Automate.

Insert a button
Select the button
Click Action on the menu bar
Click Power Automate
Power automate list will display on the right side
Select the Power Automate "ResetPowerBIDataset"

Change Power Automate return type to text like below

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
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

Was this reply helpful? Yes No