Forum Discussion

ohweiowei's avatar
ohweiowei
New Member
2 months ago
Solved

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 response

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support

3 Replies

  • 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.

     

     

    • ohweiowei's avatar
      ohweiowei
      New Member

      Thank you for the clarification. This information was very helpful and confirms exactly what I was seeing.
      Best regards,
      Jens

  • v-prasare's avatar
    v-prasare
    Community 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 response

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support