ODBC in standard gateway

[Anonymous]

Hello!

I have an ODBC connection which I can refresh on the server using personal gateway. I want it to go through my standard gateway as well. I have setup a datasource in the 'manage gateway' section with the same credentials i use in power bi desktop. The following error code appears when trying to refresh the data from the service:

Underlying error code: -2147467259
Underlying error message: The table contains no visible columns and cannot be queried.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: ART
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 639fc78a-2060-4bc1-886a-9d3232ff4197
Request ID: 7472f178-8daa-45a5-c5ca-af508df152b1
Time: 2022-07-19 16:20:10Z

Does anyone know what might be the issue?

[GilbertQ · Accepted solution]

Hi @Anonymous 

The error is saying that it cannot find any columns in the tables. I would suggest making sure that the user account and ODBC connections are getting back data from the query.

[Anonymous]

Thank you. Finally fixed it. Had to change the service account on my gateway and fix all credentials for it to be able to talk to my odbc connection.