Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Hi,
Please see if my solution here helps - Append data from multiple worksheets of multiple workbooks where each worksheet has a different head....
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.
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.
@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
@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/
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 70 | |
| 50 | |
| 42 | |
| 40 |