Forum Discussion

lboe's avatar
lboe
Copper Contributor
Feb 07, 2025

Azure Table Storage not accessable

Since yesterday, 6th February 2025, access from Excel to Azure Tables with Entra User is no longer possible.

The Storage Account Logs shows AuthenticationErrors.

In Excel, access to the Storage Account is done via: https://saname.table.core.windows.net

Access to the SA is done with Entra User. The users have the permission as Storage Table Data Reader.

 

We tested various storage accounts and locations but encountered the same issue.

Access via Azure Explorer, is still possible without any issues.

 

 

 

 

1 Reply

Sort By
  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Feb 08, 2025

    Please try on below:

     

    • Check Permissions: Ensure that the Entra User has the correct permissions set up in the Azure portal. Navigate to your Storage Account, go to Access Control (IAM), and verify that the user has the Storage Table Data Reader role assigned.
    • Update Entra User Configuration: Sometimes, reconfiguring the Entra User or refreshing the authentication token can help. Ensure that the user's permissions are correctly recognized by Excel.
    • Review Azure Table Storage Settings: Make sure that the storage account and table settings are correctly configured to allow access via Entra User. 
    • Check for Updates: Ensure that both Excel and your Azure services are up to date. Sometimes, updates can resolve compatibility issues.

Resources