In Power Query, error when merging 2 tables. datas are correct before expanding datas

[lolostudios]

Hello,

Since, I updated the Version : 2.127.1080.0 64-bit (mars 2024), I have an issue when I merge 2 tables.

In my previous version (October 23), it worked. 

I have to merge 2 tables coming from dataflows.

The first table is "SAP_operations" and  the second table is "SAP_Routing". I use 3 keys : "routing_number", "routing_group", "activity_type".

When I check the first row, the results are correct : I want the index in the SAP_routing that is equal to 1

And when I expand datas, this first row shows index equals to 3.

I tried to join the 2 tables using Numbers or Text but it is the same issue.

Is it possible to give me advices?

[Anonymous]

Hi @lolostudios 

Power BI Desktop has been updated to version 2.128.751.0 64-bit (April 2024), you can download the latest version and test it to check if the issue still exists.

https://www.microsoft.com/en-us/download/details.aspx?id=58494

Best Regards,
Community Support Team _ Ailsa Tao