Get from Folder

[lastnn30]

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 tried to combine them but got an error message. Please see screenshots and also the folder can be found here:

https://drive.google.com/drive/folders/1A13tH0mox6Izt4Thh4uRao2vR0l_MiB-?usp=sharing

[lastnn30]

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 · Accepted solution]

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

[dhruvinushah]

Can you post the screenshot of the error? 

If it's a data combination error, try loading each of the data files as individual queries. Have one query for feb and one for Jan. 

Give thumbs up. Thanks!