Share via

Unable to connect to Azure Table Storage from PowerBI

Chandu D 21 Reputation points
2021-11-29T22:17:20.737+00:00

Unable to connect to Azure Table Storage , on dialog prompt to enter URL or Account name , displays error " Account name must be .. and numbers" The account name has hyphens (-) between words, The power BI desktop client does not support this . How do I solve this ?

153457-image.png

Further , if I provide an account name with no hyphens(-) in it, now it throws "Unsupported Media type" error.

153493-image.png

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
161 questions
0 comments
Accepted answer
  1. Saurabh Sharma 23,771 Reputation points Microsoft Employee
    2021-12-01T20:50:01.37+00:00

    Hi @Chandu D ,

    Azure table storage connector and CosmosDB connector in PowerBI are different and you are trying to connect to a CosmosDB Azure Table using an Azure Table connector which will not work here and thus you are getting this error.
    In order to connect to a CosmosDB account from PowerBI you need to use the CosmosDB Connector however connecting to Azure Cosmos DB with the Power BI connector is currently supported for Azure Cosmos DB SQL API and Gremlin API accounts only and thus you won't be able to connect to CosmosDB Azure table using PowerBI as this is not supported.

    Also, Power Bi is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://community.powerbi.com/

    Please let me know if you have any other questions.

    Thanks
    Saurabh

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,986 Reputation points Microsoft Employee
    2021-11-30T22:24:17.26+00:00

    Hi @Chandu D Thank you for posting your question on Microsoft Q&A.

    I have tried to repo the issue from my end and I was able to successfully connect to Power BI
    These are the steps are followed

    1. I created a storage account and a Table then copy the part highlighted in yellow to connect to Power Bi
      You will also need to copy the account access key from access Key tab (in yellow)
      List item

    Let us know if you are still facing the same

    Regards,
    Oury

    0 comments
  2. Chandu D 21 Reputation points
    2021-12-01T00:24:10.787+00:00

    @Oury Ba-MSFT - Thanks for your response . Looks like your repo steps is slightly incorrect . Do this :

    1. Create Cosmos DB resource and select the Azure Table option. like so :
      153857-image.png
    2. Create DB account name that has dashes/hyphens in it , like "test-db-tables"
    3. Get the Account name / Endpoint url from the connection string as you see here
      153808-image.png
    4. Try connecting it from PowerBI using the Account name / Url from the previous step .

    Hope this should help to reproduce the issue I'm facing.

    later ..
    Chandu