EMERGENCY || DATA EMPTY ERROR With MongoDB || Emergency

Hi PremK ,

When using MongoDB Atlas SQL or ODBC drivers with Power BI, it's essential to ensure that the data types and structures are compatible. MongoDB's flexible schema might include nested documents or arrays not directly supported in tabular models like Power BI expects. You might need to preprocess or transform your data in MongoDB or during the import process in Power BI to flatten these structures.
And Power BI's data source privacy settings can sometimes cause unexpected behavior when combining data from multiple sources or when the data source is considered sensitive. Try adjusting the privacy settings for your MongoDB data source in Power BI to 'Public' or 'Organizational', ensuring that Power BI can freely access and combine the data as needed.

And please ensure that your MongoDB Atlas SQL and ODBC driver configurations are correct and up to date. Incorrect configurations can lead to incomplete data retrieval.
MongoDB Atlas SQL interface connector (Beta) - Power Query | Microsoft Learn
www.mongodb.com

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.