Changing a power query source

This seems very basic, but haven’t figured it out. I have an existing Power Query based on loading a table from a single Excel file. I want to replace the source with a folder containing multiple Exc...

BI & Data Analysis

excel

ahhk2000

Copper Contributor

Mar 13, 2023

Thanks, but the issue is that the current file path is a single Excel file. Changing the data source doesn't seem to allow me to select a folder and specify to combine multiple files.

NikolinoDE

Platinum Contributor

Mar 17, 2023

ahhk2000

Combine files (binaries) in Power BI Desktop

Combine Multiple Excel Workbooks in Power Query

How to Combine Tables with Power Query

According to the search results, there are several steps you need to follow1234.

A brief summary is:

Create a query from a single Excel file and convert it to a function

Create a query from a folder and select the Combine Files option

Apply the function to each file in the folder and combine all the data

You can view the search results for more details

For more precise information, I am unfortunately also overwhelmed, as far as pq is concerned, my knowledge is limited. Don't know if the problem is with PQ or with Excel itself.

If all this doesn't help, maybe starting in safe mode and trying the changeover there would help to see if it's Excel, but none of this grant.

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)

Forum Discussion

Changing a power query source

Resources