EMERGENCY || DATA EMPTY ERROR With MongoDB || Emergency

[PremK]

In MongoDB  i have 11 Collections  In a DB named OPTIORX. All Collections contains multiple documents and values. 

I had connected this DB  with PBI ( throug 2 methods - 1. Using  Get Data - MongoDB Atlas SQL ( Beta ) - Atlas SQL URL ,,||  2. Using Get Data - ODBC - Atlas SQL ODBC Drivers  )

While selecting the required Tables ( Collections ) from the DB,  Only some tables  ( 4 out of 11 Tables ) previews ALL The FIELDS with its respective Data Values in it ( Columns and Rows ) But Other Tables showing error like most of the COLUMNS WERE EMPTY

But  actually All the Columns have Data Values in MongoDB  Data Base. i have no idea why the error is showing

I have tried multiple ways to resolve this error like - cleared Cahe,  in Data Source Setting Cleared All permissions and Reconnected Them,  But all my efforts gone waste.

Please guide me to Resolve this error and bring all the Table data's into PBI....

[Anonymous]

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.