Forum Discussion
Refreshing PBI dataset using Power Automate
Hi There,
I am trying to refresh data in PBI report using Power Automate. I have inserted a Power Automate flow but it does not refresh the data as reflected on the data source (excel sheet).
Where as when I use PBI desktop app Refresh button in Home it refreshes the dataset and reflects it in the PBI report. Seeking help here if some one can help me how to refresh data set using Power Automate.
Kind Regards
MK
4 Replies
Anonymous , refer if these can help
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Hi amitchandak Thank you for your feedback. I have tried both of these solutions in the past and they dont work. Not sure if its because my excel file is not on one drive or sharepoint that could be causing refresh not to trigger.
Kind Regards, Muneeb
Hi Anonymous ，
You can refer the following links to get it, hope they can help you resolve the problem.
Using Power Automate to Refresh Data In Power BI
Refresh Power BI Dataset from Report using Power Automate
How to Schedule Unlimited Power BI Dataset Refreshes with a Simple Power Automate
In addition, is the excel file stored locally or in the cloud? If it is on-premise, you need to install and configure a gateway first. Please note that keep the gateway online. Then add the source to the gateway . You can refer to the following document to complete the above operations.
The Power BI Gateway; All You Need to Know
Install and register gateway
Add gateway data source
Best Regards
