Power BI, API, ADF: Refresh does not always work.

[Anonymous]

Hi,

I have followed this instruction to refresh my dataset with every run of the ADF pipeline. 

https://www.moderndata.ai/2019/05/powerbi-dataset-refresh-using-adf/

However, the issue is, that it does not always work. The action would be marked as completed on the ADF side, and I am also able to see it as completed in the Power BI refresh history. Therefore, I am not able to implement a retry logic, since it's not marked as failed there.

The run at 8:40 AM was triggered from the pipeline, and you can see that it had lasted only for few seconds. On the other hand, the refresh at 9 AM, took almost 15 minutes, and I was able to see the up-to-date data in the Power BI. However, the difference is that the one at 9 AM was a scheduled refresh of my dataset(not related to the pipeline runs). It looks to me almost like a bug, since the call I make is correct, the response is correct, the PBI appears to refresh the dataset, but the dataset does not really refresh.

Thank you for any hints!

[v-deddai1-msft]

Hi @Anonymous ,

I don't have good knowledge about adf. But please check if have grant api permission when you register app :

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai