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]

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

[tracytran]

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

[StalinPonnusamy]

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

[StalinPonnusamy]

Hi @tracytran 

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

Thanks,
Stalin - Learn To Illuminate

[tracytran]

@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?

[tracytran]

@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?

[StalinPonnusamy]

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

[tracytran]

@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 

[StalinPonnusamy]

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