Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Alienvolm
Helper IV
Helper IV

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

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

 

Alienvolm_0-1637590441283.png

 

Alienvolm_1-1637590457544.png

 

Alienvolm_2-1637590476261.png

Alienvolm_3-1637590529508.png

Any suggestions? 

 

Thanks! 

 

~ Alienvolm

 

3 REPLIES 3
adelheni
Helper III
Helper III

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
Community Support
Community Support

Hi @Alienvolm ,

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

vkalyjmsft_0-1637808922084.png

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.

 

 

Hi, 

 

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

Alienvolm_1-1637840987654.png

 

 

 

Now I get this error message: 

Alienvolm_0-1637840930684.png

 

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

 

Thanks in advance! 

 

~Alienvolm

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.