Forum Discussion

Molleti's avatar
Molleti
New Member
2 years ago
Solved

Merging query in Power BI

Hi Team, I have a table with around 4L lines with a common ID ( index) - FACT table I have the same Index in another table - the DIM table. when I did merger these two queries I was able to see a...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

     

     

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Molleti 
    That's all I can suggest without having your files to work with...

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Molleti 
    According to your description, we are talking about Excel files, just save them on one drive or something similar and share them with the link

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Molleti 
According to your description, we are talking about Excel files, just save them on one drive or something similar and share them with the link