Forum Discussion
Solved
Unable to refresh dataset using power automate
Hi All, I have created a flow in power automate to refresh and export my power BI query to a csv file. Everything works except the dataset is not refreshed. The flows run without any e...
Ron19 , Have you tried these steps
https://www.mssqltips.com/sqlservertip/7414/refresh-power-bi-dataset-integrate-power-automate/
amitchandak
Super User
Super UserRon19 , Have you tried these steps
https://www.mssqltips.com/sqlservertip/7414/refresh-power-bi-dataset-integrate-power-automate/
Hi amitchandak ,
I have added the flow and triggered it, but it didn't do anything. It is not triggered the refresh and didn't appear in the refresh history.
The last refresh history was yesterday that was run by schedule power automate.
Below is the error message.Data source error: It looks like scheduled refresh failed because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Cluster URI: WABI-EAST-ASIA-A-PRIMARY-redirect.analysis.windows.net Activity ID: 00000000-0000-0000-0000-000000000000 Request ID: d0842d9a-b780-4427-b3b1-8599010f9260 Time: 2023-07-10 07:30:05Z I figured out the missing credential error, so I setup the personal gateway.
However when I run the refresh dataset, it will keep on retrying. Not sure what is the problem
