create table from one of muliple workbooks connected via SharePoint site

[BennyH]

Hi Community,

We have PowerBI connected to an online SharePoint site, pulling all the available xlsm workbooks contianed within the site. We would like to create a single table from just one of the available workbooks. All the workbooks have the same source named worksheet, DATA_RAW. The intial Query is as follows.

We're using online SharePoint so owners can add new workbooks as needed without having to manual add it to the PowerBI.  For example, we want to create a table of just the Client.xlsm, first workbook in the Query table and the worksheet is DATA_RAW.

Any help is greatly appreciated, thank you in advance.

[PwerQueryKees · Accepted solution]

cant see your m ci=ode. BUT, its easy. Sort the result you showed in the screenshot and make sure the file you need is on top.

lets say you called that stap final_file_list

If you refer to final_file_list{0} you get a record.

Click on the [Content] field en the correct excel is openened and loaded.

If you dont get this to work, share the M code you got and the error/result....