Forum Discussion
Merging query in Power BI
Hi Molleti
It is difficult to answer a question like this without seeing the data.In terms of general tips:
1. When importing data to PBI, a data "change type @ step is always added. Try to remove it before merging the two tables.
2. make sure the key columns are the same data type
3.. Try to trim and clean the key column in both tables if the are texts
also take a look at the linked article about merging trouble shooting :
https://thefdtc.com/powerquery/why-is-my-merge-not-working/If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
HI Ritaf,
Thank you for your quick reply and suggestions. I have done the above steps but still have issues.
As I mentioned I have an issue with one index ID only and the rest all are successfully merged.