New variables from MongoDB collection are not showing

Anonymous · ‎09-21-2023

What else can I do? I have new variables available in my documents / collection in my MongoDB dwh but they are not showing in PBI.

What I have already tried

- wait and try again

- close PBI and reopen

- refresh sources

- add same source again

- refresh preview in PowerQuery

What else can I do?

Ritaf1983 · ‎09-21-2023

Hi @Anonymous

It seems a known issue and refers to the connector.
Please refer to the linked discussion, seems that there are some workaround with python that can help.

https://www.mongodb.com/community/forums/t/i-dont-receive-all-fields-in-power-bi-from-mongodb-atlas-using-odbc/114259/15

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Ritaf1983 · ‎09-21-2023

Hi @Anonymous

It seems a known issue and refers to the connector.
Please refer to the linked discussion, seems that there are some workaround with python that can help.

https://www.mongodb.com/community/forums/t/i-dont-receive-all-fields-in-power-bi-from-mongodb-atlas-using-odbc/114259/15

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile