Dashboard in powerbi after migrating from mongo 5.0 to mongo 7.0

Mario_Gonzalez · 2024-10-01T21:08:49.301Z

Hi all. I have a Powerbi dashboard connected to my mongo atlas 5.0 cluster via Mongo odbc, with a Power bi gateway. I want to know if when I update the version of Mongo , the data update will work or do I have to change something in my power bi environment.

thanks in advance

Jennysson_Junior · 2024-10-01T22:24:04.500Z

When you update your MongoDB version (from 5.0 to a newer version), in most cases, your Power BI setup using MongoDB ODBC should continue to work without any major changes.

To minimize risk and ensure a smooth transition, I recommend breaking down the upgrade into smaller, more manageable steps:

Move from 5.x to 6.x, testing thoroughly at each stage.
Finally, upgrade from 6.x to 7.0.

By upgrading in smaller steps, you mitigate the risk of encountering unexpected issues, and it becomes easier to troubleshoot and resolve them incrementally.

Mario_Gonzalez · 2024-10-02T09:35:31.791Z

Hi Jennyson,

thank you very much for your comment. I stay calmer. Yes, we are going to do it as you indicate: first we go from 5 to 6, we confirm that everything is fine, and then we will go from 6 to 7.0.

I made the post because I have read comments that if there were big changes in the database schema, the integration with Power BI could fail. I’m not an expert on this and I’m afraid it will happen.

Do you have any tip to ensure that there are no changes and it works?

Thanks again

All the best

Jennysson_Junior · 2024-10-02T11:30:06.918Z

To ensure everything goes smoothly and to avoid any issues with Power BI integration after the MongoDB upgrade, the best thing you can do is thoroughly review the Compatibility Changes Page for each MongoDB version.

6.0 Compatibility

7.0 Compatibility

Mario_Gonzalez · 2024-10-03T08:54:03.205Z

Thanks so much Jennyson.