Present URI in database as clickable link

I have a table in a SQL Server 2019 that stores URI’s like this:

documentID | documentlink
1 | \serversharedocumentidContract.pdf
2 | \serversharedocumentidSalesnumbers.xlsx
3 | \serversharedocumentidNicePicture.xlsx

These values are stored as nvarchar. Is there a way to make these clickable? So that, when this table is for example read by PowerQuery users only have to click the link to open the file? It is assumed that only those filetypes are allowed for which the users have applications to view those files.

This does not necessarily have to be in SQL Server itself. If someone could tell me how to make it clickable in for example Excel or PowerBI, I would be gratefull also.

Answer

Adding file: in front of documentlink makes Excel makes it into a clickable link. My Google-fu abandoned me.