Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI have functionality to pick automatically if new file available in the share point folder

I have two sets of files (A and B). Each A and B file appended with year like A_2018,A_2019,B_2018,B_2019. A file has different columns and B file has different columns. Now my query is, do Power B...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

OK, thought question was going a different route. What do you mean by pick automatically?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    First time we will append all the data respective to A and B file then load into single table for each file.  

    If buiness user place  A and B new files for next year in seperate spreadsheet then Power BI have to identify the respective file name and append new file data with exisiting data automatically.