Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

lolostudios_0-1712609239712.png

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

lolostudios_1-1712609758670.png

 

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

 

 

Is it possible to give me advices?

 

Status: Investigating

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

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

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