Connection error to Azure Table - The remote name could not be resolved

[Anonymous]

Hello, 

About two months ago I connected Power Bi to an Azure Table. Everything went through without any issues. I am still building the solution, so I haven't regularly kept track of updates. Some time ago, I noticed that the data preview in the Power Query Editor stopped updating on October 18. When I try to refresh manually, I get an error. 

I doublechecked the connection URL and the key, and they are correct. There are no error on the Azure side. 

One of my colleagues tried to connect to the table through Excel by following this procedure: https://arminreiter.com/2016/10/working-with-azure-table-storage-and-excel/ and everything worked fine. We can see updated data in the Excel table.

I tried to open a brand new Power BI report, crealed cache and stored credentials, and still cannot connect to it. I can see the preview of the table just up to October 18 (see errors below): 

Any suggestions? 

Thanks! 

~ Alienvolm

[adelheni]

Hi, you can try this method which worked for me. 

Try to click "File"->"Options and Settings"->"Options"->"Data Load"-"Clear cache".
Or you can some of the available platforms for free to connect any type of data to power bi without any issue.

https://windsor.ai/ has been great for me and my job.

[v-yanjiang-msft]

Hi @Anonymous ,

Is your storage account name “storageaccountbillb81c6”? You can try to enter the storage account name directly in the bellow area.

Please check the status of your storage account once more"https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, 

I created a new report, cleared the existing permissions, and inserted the table name, and the token, as suggested: 

Now I get this error message: 

Is there anything specifically I should look for in the Azure Table? 

Thanks in advance! 

~Alienvolm