Forum Discussion
Connect to folder withing document library?
Hi NitroMDX ,
Try connecting to a site first.
Power Query SharePoint folder connector - Power Query | Microsoft Learn
Then create a new parameter:
Replace 'sitename1' with the parameter 'SITENAME' you just created.
Right-click on the query and select Create Function.
Then introduce a table where you need to place the names of the 21 sites.
Add column --> Invoke custom function
After successfully fetching the data from the site, you can expand the table to further transform the data.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi NitroMDX ,
Try connecting to a site first.
Power Query SharePoint folder connector - Power Query | Microsoft Learn
Then create a new parameter:
Replace 'sitename1' with the parameter 'SITENAME' you just created.
Right-click on the query and select Create Function.
Then introduce a table where you need to place the names of the 21 sites.
Add column --> Invoke custom function
After successfully fetching the data from the site, you can expand the table to further transform the data.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum