Forum Discussion
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/
Similar threads in MongoDB Community:
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
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/
Similar threads in MongoDB Community:
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!