Forum Discussion
Folder Combine Wizard creates sample file queries but does not generate final combined query
Hello,
I believe I have found a reproducible issue in Power BI Desktop (June 2026 release) related to Folder Import and Combine Files.
Environment
- Power BI Desktop June 2026
- German user interface
- Excel workbooks (.xlsx)
- Source objects are worksheet tabs, not Excel Tables
- All files have identical structure
- All files contain a worksheet named "Tabelle1"
Steps to reproduce
1. Get Data -> Folder
2. Select a folder containing multiple Excel files
3. Choose Combine
4. Select worksheet "Tabelle1"
5. Choose Transform Data
Expected result
Power Query should create:
- a sample file query
- the transformation query/function
- a final combined query that applies the transformation to all files and returns the combined dataset
Actual result
Power Query only creates:
- Fakten
- Beispieldatei
- Parameter
- Beispieldatei transformieren
The query "Fakten" only contains the following steps:
- Source
- Filtered Hidden Files
The generated M code is:
let
Quelle = Folder.Files("...")
#"Gefilterte ausgeblendete Dateien" = Table.SelectRows(Quelle, each [Attributes]?[Hidden]? <> true)
in
#"Gefilterte ausgeblendete Dateien"
No transformation function is applied to the Content column and no final combined table is generated.
The query "Beispieldatei transformieren" correctly navigates to worksheet "Tabelle1" and displays the worksheet data, so the sample-file transformation itself appears to be created successfully.
Additional observation
If I manually expand the "Content" column afterwards, Power Query generates another set of helper queries and then successfully creates the combined result.
This suggests that the wizard creates the sample-file transformation but fails to connect it to the main folder query.
Can anyone reproduce this behaviour in the June 2026 release?
Thank you.
Kind regards
Jens Huthmann
Hi ohweiowei ,
You are using the new Power Query experience correct? I can confirm that this error is happening in the new power query experience for folder.
This is a know error by MSFT and they are working on the new Power query experience and trying to solve this since it's in previe errors are expected.
For now for the folder option you still need to revert back to the previous Power Query Experience and everything should work properly.Hi ohweiowei,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
MFelix ,Thanks for your prompt responseThank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
3 Replies
- MFelixSuper User
Hi ohweiowei ,
You are using the new Power Query experience correct? I can confirm that this error is happening in the new power query experience for folder.
This is a know error by MSFT and they are working on the new Power query experience and trying to solve this since it's in previe errors are expected.
For now for the folder option you still need to revert back to the previous Power Query Experience and everything should work properly.- ohweioweiNew Member
Thank you for the clarification. This information was very helpful and confirms exactly what I was seeing.
Best regards,
Jens
- v-prasareCommunity Support
Hi ohweiowei,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
MFelix ,Thanks for your prompt responseThank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support