Import Excel from Folder

[askspepsi]

Greetings,

I am trying to import excel using folder option and i have create some steps and created report 

and i added another excel to the folder and manually refresh but power query don't take the new excel all the steps, 

i have attached the screen shot of the excel and the Steps applied.

please help me to resolve this.

[Ashish_Mathur]

Hi,

Please see if my solution here helps - Append data from multiple worksheets of multiple workbooks where each worksheet has a different head....

[v-yingjl]

Hi @askspepsi ,

When import excel from the folder, all the files will save as a Binary file, we need to import them into power bi and expand them one by one. Based on your description, not certain what is your expected output, when we add a new file in the folder, after refreshing the folder in power bi, it will be there as a binary file initailly. 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[jairoaol]

the structure of the files must be the same and the name of the excel sheet the same and located first sheet.

validate that you don't have hidden leaves too.

[Anonymous]

@askspepsi when you try to import excel with folder option you need to make sure the schema of the file is same like the headers of all the excel file must match and also the datatype

[amitchandak]

@askspepsi , You are importing as a folder and combining?

refer if needed

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.