Unable to refresh dataset using power automate

[Ron19]

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 error and below is the refresh output.

I need to manually press refresh button in power BI to get the latest data exported to csv.

Please advice if I did anything wrong. Thank you.

[amitchandak · Accepted solution]

@Ron19 , Have you tried these steps

https://www.mssqltips.com/sqlservertip/7414/refresh-power-bi-dataset-integrate-power-automate/

[Ron19]

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

[Ron19]

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