Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Query editor loads same files multiple times

Hey community,   could someone please help me with the following:   I have PowerBI connected to a folder from which it loads all excel files in it. Up to here no problem, but: The data editor l...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

darentengmfs 

any idea ...? please let me know if you need to know more!

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
5 years ago

AnonymousI suspect that the query loaded up duplicate rows in #"Merged Queries". Can you please count the rows in #"Removed Columns" and #"Expanded Sheet2". If there is 1-1 relationship they will return same number of rows, if duplicated will row count increase. Please test it out and let me know.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    smpa01 thank you for supporting!

     

    #"Removed Columns" has 39312 rows,

    #"Expanded Sheet2 has 275184 rows. 

     

    the right row count should be 39312 rows, currently is 275184 rows

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Anonymousone of the possibilites might be you have duplicate value on the right table on the join key column.

       Can you remove duplicates from the join key column from the right table and trythe join again. It should match 1-1 and you would have the same number of rows after join.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        smpa01 thanks for coming back.

        sorry, I cannot quite follow ... what am I supposed to do where?