Refresh Dataset REST API in Power Automate

Anonymous — Wed, 04 May 2022 20:25:02 GMT

Hi,

I'm testing the use of the Power BI action 'Refresh a Dataset' in Power Automate for two datasets in the same workspace and I'm getting a strange outcome for one of them.

For one of my datasets, I am getting the expected outcome, which is the specified dataset refreshes and in the Refresh history UI I can see, under 'Schedualed', my API working with type 'ViaApi'.

However, I'm getting an odd result for the second dataset. This dataset is within the same workspace.

Instead it is failing because for some reason it is apearing under 'OneDrive' and Type 'On-demand'.

I know that On-demand is not supported by the Get Refresh History API with is the GET version of the above Post service, I'm not too interested in the On-demand/OneDrive path. I just need all refresh requests to follow the 'Schedualed'/ 'ViaApi' path.

I have also tried building this particular API service as a custom connector and get the same results.

Everything is the same, even the connection used, apart from the datasetId.

Any insight would be much appreciated, thanks!

Re: Refresh Dataset REST API in Power Automate

Anonymous — Mon, 09 May 2022 09:03:29 GMT

Hi @Anonymous ,

What is the data source of the second dataset? Is it OneDrive? Judging from the message inside the Refresh history, it is possible that the account is unavailable. You can refer to the link below to activate the account.

Reactivate an account that has been blocked

Alternatively, you can run the REST API below to get the refresh history of the second dataset.

Datasets - Get Refresh History

Best Regards

topic Re: Refresh Dataset REST API in Power Automate in Developer

Refresh Dataset REST API in Power Automate

Re: Refresh Dataset REST API in Power Automate