Hello, Thank you for posting in Q&A forum. I have found a relevant solution for you. Please let me know if this is what you are looking for Combine Data from Multiple Sheets in an Excel file with Power Query (mssqltips.com) Please Note: This response contains links to third parties, which we provide for convenience of reference, and Microsoft cannot guarantee the validity of any information and content in this link. Best regards， Jill Zhou If the Answer is helpful, please click " Accept Answer " and upvote it.

how to combine all sheets in power query

slardar22 0

User's image

1 answer

Jing Zhou 7,105 Reputation points Microsoft Vendor

2024-07-11T09:22:59.1666667+00:00

Hello,

Thank you for posting in Q&A forum.

I have found a relevant solution for you. Please let me know if this is what you are looking for

Combine Data from Multiple Sheets in an Excel file with Power Query (mssqltips.com)

Please Note: This response contains links to third parties, which we provide for convenience of reference, and Microsoft cannot guarantee the validity of any information and content in this link.

Best regards，

Jill Zhou

If the Answer is helpful, please click "Accept Answer" and upvote it.
Please sign in to rate this answer.
Jiajing Hua-MFST 10,560 Reputation points Microsoft Vendor

2024-07-12T02:04:24.53+00:00

Hi @slardar22

Please refer to Jing Zhou's sharing link. In this link, there are 3 methods to combine all sheets in a query.

Create connection queries to the data in each sheet and then combined all via Append Queries as New command.

If the workbook may have new worksheets, you may create a connection query to the workbook instead of each sheet. After process the data, then expand a Table-Structured column.

Use = Excel.CurrentWorkbook() to establish a connection to the current workbook. By this way, the workbook could provide an overview of the raw data.

Jiajing Hua-MFST 10,560 Reputation points Microsoft Vendor

2024-07-22T06:11:57.33+00:00

Hi @slardar22

Sorry to bother you, just want to check whether our information is helpful to you.

Any further issues, welcome to post back.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

how to combine all sheets in power query

1 answer

Your answer