Authorization error prevents power BI Dataset refresh in Azure Synapse workspace

Question

The web activity intended to refresh the Power BI dataset within the Azure Synapse Workspace encountered an error:

{
"errorCode": "2108",
"message": "The Web Activity failed with HttpStatusCode - 'Unauthorized', and message - ''",
"failureType": "UserError",
"target": "StartProcessingPowerBIRefresh",
"details": []
}

It's worth noting that while I can refresh the Power dataset using Logic Apps and the Power BI App, I encountered difficulties when attempting to do so from within the Synapse Workspace.

Answer 1

Hi @Glasier

Welcome to Microsoft Q&A platform and thanks for posting your question here.

If you get an error while trying to refresh a Power BI dataset in your Azure Synapse Workspace, it usually means that the workspace doesn't have permission to access the dataset. This can happen because of incorrect login information or not enough permissions.     

To resolve this issue, follow the below steps:

check that the workspace can access the dataset, make sure the login information is accurate and up-to-date, and confirm that the data sources used in the dataset are set up correctly with the necessary permissions.      

If you're using basic authentication, make sure the login information is safe and the data sources have the necessary permissions. If you're using Azure Active Directory authentication, ensure that the correct service principal has the right role in Power BI and that the workspace has the necessary permissions.  
        

 Reference
https://learn.microsoft.com/en-us/azure/data-factory/data-factory-troubleshoot-guide#error-code-2108

I hope this information helps you. Let me know if you have any further questions or concerns.