Authorization Error

Question

Can you provide guidance on resolving an authorization error that is preventing the refresh of a Power BI dataset within an Azure Synapse Workspace? The error message received is "The Web Activity failed with HttpStatusCode - 'Unauthorized', and message - ''" (errorCode: 2108). It is important that refreshing the dataset using Logic Apps and the Power BI App is successful, but the issue only occurs when attempting to refresh from within the Synapse Workspace.

Answer 1

@krunal Thanks for using MS Q&A platform and posting your query.

The error message "The Web Activity failed with HttpStatusCode - 'Unauthorized', and message - ''" (errorCode: 2108) indicates an authorization issue with your Power BI dataset refresh within Azure Synapse Workspace. Here are some steps you can take to troubleshoot and resolve the problem:

1. Verify Credentials:

• Check if the credentials used for connecting to the data source in Synapse Workspace are valid and have the necessary permissions to access the Power BI dataset.
• Ensure these credentials match the ones used in Logic Apps and the Power BI App (if successful).

2. Data Source Permissions:

• Make sure the user or service account running the refresh within Synapse Workspace has the appropriate read access on the Power BI dataset.
• In Power BI Service, verify if the Synapse Workspace user/service account is a member of a workspace group with access to the dataset.

3. Gateway Configuration (if applicable):

• If you're using an on-premises data gateway to connect to Power BI, ensure it's configured correctly and running on the same network as your Synapse Workspace.
• Double-check that the gateway user has access to both the data source and the Power BI dataset.

4. Firewall Rules:

• If there are firewalls between Synapse Workspace and Power BI Service, verify that they allow communication on the necessary ports for data refresh.

5. Azure Active Directory (AAD) App Registration (for OAuth):

• If OAuth is used for authentication, confirm that the AAD app registration has the required permissions to access the Power BI dataset.
• Ensure the app ID and secret used in Synapse Workspace match the ones configured in the Power BI App/Logic Apps (if successful).
• While the specific error message might differ, this Microsoft document troubleshoots dataset refresh errors: https://community.fabric.microsoft.com/t5/Service/power-bi-service-dataset-refresh-error/m-p/2219340/highlight/true
• This forum thread discusses a similar authorization error with Power BI dataset refresh in Azure Synapse Workspace: https://community.fabric.microsoft.com/t5/Service/Power-BI-Dataset-Refresh-Error-Authorization-Code-is-Intended/m-p/2276195

Hope this helps. Do let us know if you any further queries.