Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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
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.
| User | Count |
|---|---|
| 16 | |
| 13 | |
| 12 | |
| 10 | |
| 7 |
| User | Count |
|---|---|
| 40 | |
| 39 | |
| 34 | |
| 29 | |
| 19 |