Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.