Forum Discussion

Vikhyat_27's avatar
Vikhyat_27
New Member
1 year ago

"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 running aggregation: Too many fields". This table is heavily nested but I feel Power BI is making fields recurring.

Anyone who has faced this issue and can help me with it.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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