Unable to connect to Azure Table Storage from PowerBI

Question

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 ?

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

Answer 1

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.

Answer 2

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)
   

Let us know if you are still facing the same

Regards,
Oury

Answer 3

@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 :
   
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
   
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