Error when refresshing dataset from PBI

[biadm]

Hi, i followed the indications from this article: https://www.moderndata.ai/2019/05/powerbi-dataset-refresh-using-adf/#comment-2610 and it fails in the last step of the pipeline (Call Dataset Refresh).

The error msg is :

Operation on target Call Dataset Refresh failed: Invoking Web Activity failed with HttpStatusCode - '401 : Unauthorized', message - ''

Any idea ? Thx!

[Anonymous · Accepted solution]

Hi @biadm ,

I think there should be something wrong in the step you get access token.

You can refer to this blog: Refresh Power BI dataset through Azure Data factory.

Try to get access token from this URL:  https://login.microsoftonline.com/common/oauth2/token

Best Regards,
Rico Zhou

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