New Keys/Columns are not appearing after adding the data to mongoDB collection

[shubham-sharma]

Hi, I'm using MongoDB with powerBI for visualizations through Mongo Atlas PowerBI connector I'm connecting my dataset with powerBI. The issue I am facing whenever I add new keys to my existing dataset through code and refresh my dataset in powerBI those keys does not appear even after 2-3 refresh also sometimes I have to restart the connector also to get those keys or change the node from the primary to secondary or vice versa.

Can someone help me with this issue, please?

[v-deddai1-msft]

Hi @shubham-sharma ,

Is there any error shown in power bi desktop? I would suggest you enable tracing in power bi desktop in File—>Option and Settings—>Options—>Diagnostics—>tick the Enable tracing —> Open traces folder, then you will find the Power BI log files.

Here's a good tool to analysis the logs. Power BI Desktop Trace Logs Analyser

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

Best Regards,

Dedmon Dai

[v-deddai1-msft]

Hi @shubham-sharma ,

It seems that something wrong with the connector. Have you ever try to use the odbc connector? Please refer to https://docs.mongodb.com/bi-connector/current/connect/powerbi/

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

Best Regards,

Dedmon Dai

[shubham-sharma]

Hi, @v-deddai1-msft I am using the odbc connector for the connection I have to switch nodes in MongoDB to get those keys.