Unable to view the data from some collections in Power BI

MongoDB Atlas
1

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

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

Thank you, it worked.