Forum Discussion
"Too many fields error" while loading data from Mongo DB
Hi, I am currently loading data from Mongo DB via ODBC connection. I have successfully made the connection and its working fine. But out of all the tables, one table is giving me error: "error runni...
Hi Vikhyat_27 ,
Based on your description, the error states that there are too many fields, and you mention that your table performs multiple levels of nesting. You could try to simplify the structure of the nested table. This may involve spreading the data or reducing the nesting level. Of course, you could also consider using MongoDB's aggregation pipeline to preprocess data before it reaches Power BI. This can help reduce the complexity of the data that Power BI needs to process.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly