Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Merge 3 files and adding monthly

Hi all,   So I am trying to merger 3 files and have monthly files added... monthly. Below are 3 files 1. Master data: which has SKU code and number of SKU in a case. This file is fix 2. Monthly D...
Need Help
pa_trick67's avatar
pa_trick67
Helper I
6 years ago

Hi Anonymous 

 

You can load the 3 file merge queries and then append in Query editor.

Can you attach your pbi file?

 

Patrick

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    pa_trick67  I have explored two options and struggling with both

    Option 1: Add them into pbix as separate files (3 files for Master Data, 2019.01 Delivery and 2019.01 Order). It works for 3 files, however, now I'm struggling to update with 2019.02 Delivery and 2019.02 Order

    https://drive.google.com/open?id=1TUG7ormFuwpLSPYWZQoi89mpeRuqL1X_

     

    Option 2. Add 3 files Master Data, 2019.01 and 2019.02 into a folder - for easier update. However, I can't merge them once they are added as in the same folder.

    https://drive.google.com/file/d/1sAqHlVBGWaxXnHpNrYd2ydlTz4FWLPDP/view?usp=sharing

     

    I'm thinking of making a folder for Delivery and another ofolder for Order, then merging them together and with Master Data. But not sure it works smoothly, or there are any other ways.