Unable to connect to the Azure table storage

Hi yunliu ,

Thanks for reaching out to the Fabric Community.

To bypass the unsupported OData format error when connecting Power BI to Azure Table Storage, the most stable workaround is to skip the native connector and use Power Query’s Web.Contents() function to directly call the Table Storage REST API with custom headers specifically setting "Accept" = application/json;odata=nometadata and authenticating with a Shared Key or SAS token this lets you retrieve and transform the JSON data without running into Power BI’s enforced metadata formatting issues during refresh, and works reliably in both Desktop and Service environments

Workaround:

Use REST API via Web.Contents() Instead of OData

This bypasses the metadata negotiation entirely:

m

let

    url = "https://<your_account>.table.core.windows.net/<your_table_name>()",

    headers = [

        #"Authorization" = "SharedKey <your_auth_header>",

        #"Accept" = "application/json;odata=nometadata"

    ],

    result = Json.Document(Web.Contents(url, [Headers=headers]))

in

    result

Works in both Desktop and Service

Lets you control headers directly

Avoids OData limitations

Power Query OData Feed connector - Power Query | Microsoft Learn

Solved: Azure Table Storage to Power BI - Microsoft Fabric Community

Solved: Re: DataFormat Error when refreshing data from Azu... - Microsoft Fabric Community

We truly appreciate your continued engagement and thank you for being an active and valued member of the community. If you’re still experiencing any challenges, we’re more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi