Forum Discussion

lastnn30's avatar
lastnn30
Icon for Post Patron rankPost 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

dhruvinushah's avatar
dhruvinushah
Icon for Responsive Resident rankResponsive Resident
4 years ago

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!