Power Query-Accessing multiple files in our organization Sharepoint site

Question

I have several reports that require analysis for monthly audit purposes. The 9 files are located in our organization sharepoint site and all are formatted differently. All files need to combined into one file to conduct analysis via vlookup to different files--each file is generated and formatted individually for combining purposes.

There is one sheet in each file but they have specific sheet names (don't know if this matters).

All files are located in a path similar to this, however, the month's scope would be different (which is what I was hoping can create a parameter for it to grab upon editing the table with respective month's scope):

https://ORGNAME.sharepoint.com/sites/TEAM'S GRP NAME/Shared%20Documents/2.%20Performed%20Controls/ARC%20-%20JE/FY23/GA-4/07-July%202022/C-SAP/Raw%20Data/FILE1 NAME.xlsx

I would like to create a parameter that grabs the file path from a table RATHER than having to update each of the individually uploaded file's path. Also, the final combined table query is around 350K lines and fails every time right at 349K lines of retrieving data.

Any assistance would be greatly appreciated as I've watched several tutorials and am unable to figure for a solution.

Thank you!

Answer 1

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

--please don't forget to Accept as answer if the reply is helpful--