Forum Discussion
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
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 ?
