2
Dec 2024
2 / 5
Dec 2024
14d ago
Sertaj_Mujawar
Dec 2024

Hi Team,

Some collection I am able to view in Power BI, and some collection I am unable to view with the below error. I have attached the error screen shot. I have created the collection with admin user. I tried dropping and recreating the collection. Even I tried creating the collection with Mongosh. nothing is working to resolve the issue. my collection is simple, It won’t have any subdocuments. Please help to resolve the issue.

Error: DataSource.Error: The table has no visible columns and cannot be queried.

Thanks,
Sertaj

error
error1058×512 50 KB

2
Alexi_AntoninoMongoDB Employee
Dec 2024

Hello @Sertaj_Mujawar This message means that there is no SQL Schema for this collection. If you can log into Atlas, go to the Data Federation Menu. Find your Federated DB instance and select the option to Manage SQL Schema. You can generate the schema and that will fix this issue.

3 months later
26 days later
Alexi_AntoninoMongoDB Employee
14d

Hello @Joao_Lucca I think this is telling us that the data within your source db is in conflict with the sql schema. But it is difficult to tell which field is the problem. Can you download and look at the ODBC log? There might be a clue there, then we can inspect the source collection and field to verify the datatype within the sql schema is accurate.


Want to read more? Browse other topics in MongoDB Atlas or view latest topics.