Unable to view the data from some collections in Power BI

Sertaj_Mujawar · 2024-12-09T11:45:25.458Z

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

error1058×512 50 KB

Alexi_Antonino · 2024-12-09T13:20:12.580Z

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.

Sertaj_Mujawar · 2024-12-09T14:00:36.521Z

Thank you, it worked.

Joao_Lucca · 2025-03-16T23:18:17.481Z

Hello, @Alexi_Antonino

I followed your advice and created the schema for the collection that was showing this error. However, after doing that, I received a new error.

Could you help me understand how I should proceed to be able to use this collection in Power BI?

error-mongo-powerbi1066×728 21.4 KB

Alexi_Antonino · 2025-04-12T02:50:04.469Z

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.