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
darentengmfs's avatar
darentengmfs
Icon for Post Prodigy rankPost Prodigy
5 years ago

Anonymous 

 

Can you share your Advanced Editor code?

  • 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