Power Query

[Syndicate_Admin]

Hello community

I wanted to ask them if it is possible in power query to obtain the access or visualization link of each of the excels that are hosted in a sharepoint folder.

attached reference image

thanks in advance

Best regards

[v-henryk-mstf]

Hi @Syndicate_Admin ,

Based on your description, I think the following blog describes in detail how to Import All Files in a Folder by power query.

Power Query - Import All Files in a Folder - Excel Off The Grid

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , You can read a SharePoint folder and with that, you can build a link ?

@ImkeF , Please suggest

[Syndicate_Admin]

Hello, is to get the access links of each excel file and place them in a custom column, is there a way to get it massively all the access links?

Best regards