DATA SOURCE ERROR With MongoDB || EMERGENCY

Hi PremK 

As only some tables have this error, this is probably not a Power BI issue. I searched the error in MongoDB community and found some similar threads. This is likely an issue with the SQL Schema. This error occurs when there isn’t a sql schema created for your underlying collection/table. You need to regenerate the SQL Schema for these collections or for the whole federated database instance. Check out these instructions for more information: https://www.mongodb.com/docs/atlas/data-federation/query/sql/sqlgenerateschema/ 

59

Similar threads in MongoDB Community:

Power BI: DataSource.Error: The table has no visible columns and cannot be queried - MongoDB Atlas - MongoDB Developer Community Forums

MongoServerError: sqlGenerateSchema command not found - Working with Data / Connectors & Integrations - MongoDB Developer Community Forums

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!