Forum Discussion
Files in folder
Hi, I wonder if anybody can help me. Im import data from an folder with 19 files this are same but one for each month. But some how the power bi make like year 2018 to double sales figures and I can...
Based on my test, I imported 19 excel files from one folder successfully by the following steps:
1. Get data -> Folder -> enter the folder path - > load
2. Edit queries -> click the icon on the right side of Content column and choose the sheet we need to combine files.
After that, we can get the table that we need:
Could you please tell me what is the type of your file and how you expand the data from all the files?
Regards,
Lydia