Search code examples
azurepowerbiazure-data-factory

PowerBI Refresh Through Azure Data Factory

I have developed a Pipeline according to the post "https://www.moderndata.ai/2019/05/powerbi-dataset-refresh-using-adf/#comment-2610".

However I keep getting an error "Invoking Web Activity failed with HttpStatusCode - 'Unauthorized', message - '' in the CALL DATASET REFRESH WEB ACTIVITY.

I haven't registered the Security Group for API access using the Service Principals. Could this be causing an issue ?.note(I am not the PowerB admin)

Not sure what is causing this issue. When I execute the same thing through a Powershell script it works fine. Not sure why it is not working through the azure datafactory.

Solution

  • Just from the error message, you don't have the permission to access/refresh the PowerBI. The post you reference also said you must has the request permission.

    Please request for the access and test again.