Merge tables gives Data Source Error URL Length Exceed

[YashwantPW]

I

When we try to merge two data tables (One Odata Project & other Assignemnt Odata) using Power Querry it gives following  Data Source Error URL Length Exceed . 

At the time of Merge we are doing a Inner Joing between both the tables and when we try to do a left join the merge works.

[v-chuncz-msft]

@YashwantPW ,

You may also try it in DAX.

https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/

[YashwantPW]

hi @v-chuncz-msft  I am using Power Query in Excel. Is there something i am do in excel.

[BHW84]

Hello,

have you solved the above issue?

thx