Get Data from Workbook & Sharepoint

Question

Hello All,I would like to have a "Master" Sheet that imports tables from a suite of 5 other sheets. and is usable by a myriad of other users.&nbsp;Unfortunately, when I use Get Data - From File - From Workbook and then select tables, it pulls them all in as local file directories.&nbsp;Eg: c://User.../thefile.xlsx etc&nbsp;How do I reference them ambiguously using the correct sharepoint links?Eg: https://[tenant].sharepoint.com/:f:/s/KzMDgGusBXkyWPuH7KdXUGuOJJOpq9g?e=jkMXfu&nbsp;&nbsp;

aaronrba · Answer

I'm using this functionalityhttps://support.office.com/en-us/article/connect-to-another-workbook-3a557ddb-70f3-400b-b48c-0c86ce62b4f5

sergeibaklan · Answer

AaronRba&nbsp;
You shall use From Sharepoint Folder connector

Here use root URL of the Sharepoint site (not link on the folder or file). Connector gives you list of all files on the site, filter it on your file, remove unnecessary columns and expand content.

aaronrba · Answer

I'm not seeing that as an option, how do I add it?

sergeibaklan · Answer

AaronRba&nbsp;
Oops... Yes, this connector is only for enterprise Office365 subscriptions, not sure about 2019. You may try if SharePoint.Files()&nbsp;https://docs.microsoft.com/en-us/powerquery-m/sharepoint-files will work directly from M-script if code it in Advanced editor.

Forum Discussion

Get Data from Workbook & Sharepoint

4 Replies

Resources