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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Greenpay2019
Frequent Visitor

Data refresh

Hello everyone,

 

I don't understang why I can Auto refresh from my old laptop with an out of date gateway but when I configure a new gateway on my new laptop I can't refresh and I get this error.

 

Erreur de source de données: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The table has no visible columns and cannot be queried."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"TRANSACTIONS_SOURCE"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: TRANSACTIONS_SOURCE.
URI du cluster: WABI-SOUTH-AFRICA-NORTH-A-PRIMARY-redirect.analysis.windows.net
ID d'activité: a363e721-3106-4859-af5e-b509d5616914
ID de demande: 9d9541c3-feb7-9d68-8f57-32925c70e1ce
Heure: 2023-07-27 16:26:19Z

 

 

I ve already check the credentials and the different settings I'm desperate for some help

2 REPLIES 2
d_gosbell
Super User
Super User

This part of the error "The table has no visible columns and cannot be queried" indicates that there is a problem in your query or in the data source and it is returning no data.

Thank you for your feedback. I have no issue refreshing with my old gateway on my previous laptop like I specified. The issue happens when I create a new gateway on an another laptop. Why is it only happening with others laptop. I tried on two different laptop and still get the same error. Is it user related ?

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.