Forum Discussion
Getting this error: datasource.error: the table has no visible columns and cannot be queried.
Hi alozano93 ,
This error might be caused by one of the following reasons:
- The data source connection is not configured properly. You might need to check your credentials, server name, database name, and port number in the Data source settings.
- The collection schema is not compatible with Power BI. You might need to modify the schema or use a different connector to access your data.
- The collection contains nested or complex data types that Power BI cannot handle.
To troubleshoot this issue, you can try the following steps:
- Refresh the data source and make sure it is up to date.
- Use the MongoDB Connector for BI instead of the ODBC connector. This connector can handle more complex data types and schemas.
- Use the Power Query Editor to preview and shape your data. You can apply filters, transformations, and aggregations to your data before loading it into Power BI.
Solved: The table has no visible columns and cannot be que... - Microsoft Fabric Community
Incorrect Warning Message, “This data source contains no visible - Microsoft Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous, Thanks for your support.
- The data source connection is not the issue, I’m working with 20 other collections from the database and using the same connection.
- It doesn’t have nested/complex data types, other collections have them and it doesn’t seem like an issue.
- The data is up to date.
- I’m using MongoDB Atlas SQL.
- Cannot get to Power Query Editor with that one:
- If I use any other collection, no problem:
- Solved: The table has no visible columns and cannot be que... - Microsoft Fabric Community : In this case, the user cannot pull any table, I’m having an issue with just one in particular and I have the latest Gateway installed.
- Incorrect Warning Message, “This data source contains no visible - Microsoft Community
apache spark - Querying Delta.io tables with Power BI returns the "The table has no visible columns"... : In this case, spark issue.
Any other insight will be appreciated.
