Refresh Dataset isnt working

[butterscotch]

Hello !

I have a power bi file and powerapps embedded in it, the purpose of the powerapps is to modify dataset in power bi, im facing an issue where everytime i modify field in powerapps and click save and refresh, the refresh process wont happened. i used power automate to refresh the dataset when i check power automatate the flow works succeeded. 

Thank you in advance !

[PijushRoy]

Hi @butterscotch 

what is the datasource of the Power BI and Power App
After update, if you refresh after 10-15 minutes, is it working? I means it is taking time to reflect new data or never working.

[butterscotch]

the datasource is excel, the refresh process works right away if i directly refresh in power bi (figure 1). but it doesnt work if i click refresh button that i created using power automate (figure 2).

figure 1

figure 2

[Anonymous]

Hi @butterscotch ,

It seems like that you’re experiencing an issue with refreshing Power BI dataset using Power Automate. However, it works well when refresh it in Power BI Desktop. Where you store the excel file? Is the excel file in your local directory or online location like OneDrive or SharePoint? You can store that excel file in an online location like OneDrive or SharePoint, then refer the following links to refresh the report.

Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI

refresh excel every morning - Page 2 - Power Platform Community (microsoft.com)

Best Regards