ello, 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 5,135 Reputation points Microsoft Vendor

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

ello,

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 7,545 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.
Sign in to comment

Share via

how to combine all sheets in power query

1 answer