Forum Discussion
Re: Combining multiple quarterly workbooks into one master workbook.
Brian, I added the parameter to the attached file.
When you start with Power Query most probably you'll see the warning what your version could be incompatible with queries - ignore it.
Open right pane with queries (Data-> double clink on Queries and Connections). It shall be like
Double click on pFilePath and change it on yours. Now double click on Test and Refresh it. Before that ignore all errors.
Group of queries under Transform... is generated automatically, you query is only Test.
No RepliesBe the first to reply