Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
4 years ago
Solved

Get from Folder

Hi I am trying to Get-->From Folder but I keep getting error message and nothing loaded. I have 2 files which have 1 table each  and I want to combine and load them to a visual in Power BI. So I tr...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, lastnn30 

    If you want to use the folder connector to consolidate the data in these excels, first make sure that each excel in the folder has the same table structure (same column fields).

    The error you are showing may be due to some fields that do not match between the new table added and the previous tables.

    Best Regards,
    Community Support Team _ Eason

lastnn30's avatar
lastnn30
Post Patron
4 years ago

Hi

Thanks for your reply. But I want to do "Get from Folder" so next time if I add another file to the folder, I wont need to repeat the steps to combine all files. Please see attached screenshots for the error msg and the power query. Thank you once again.

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, lastnn30 

If you want to use the folder connector to consolidate the data in these excels, first make sure that each excel in the folder has the same table structure (same column fields).

The error you are showing may be due to some fields that do not match between the new table added and the previous tables.

Best Regards,
Community Support Team _ Eason