Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
raman_vee
Regular Visitor

SharePoint Document Library File URL

Hello all,

 

I am importing a document library into Power BI/Power Query and so far I have been able to figure out how to extract the metadata which is great for reporting/tracking key documents. I would like to insert links to certain documents in my report as well. I have not been able to do this yet and cannot find an up-to-date method for adding a URL for the file. 

 

The image below shows the relative URL which I know does not work. I tried transforming it by adding in the https:// etc. in front but that did not work either.

 

Screenshot 2022-11-11 095608.png

1 ACCEPTED SOLUTION

I was able to get it working now, just be typing in a blank space, replaced the relativeURL with %20 and then modified the '/sites' to add in the http:// etc. each file works now, your suggestion was nearly correct but the u:/r:/ did not make it work. Thanks so much !

View solution in original post

5 REPLIES 5
raman_vee
Regular Visitor

Hi ! Thanks for the response !

 

I was able to get this working actually using the "linkingurl" field that I extracted from the metadata in Power Query, but it only seems to work for Microsoft365 documents, not .pdf, .txt files etc

 

I put them in a table with webURLs, I am extremely close to getting where I need to be. I basically want a document summary dashboard page for my project reports.

 

Here's what I got so far:

 

The purple box in the first photo, ideally I want clickable links to all those documents. But it won't work for non MS office docs.

 

The green box shows where I got the linking url information for my table, as you can see it only shows up for the MS offfice files.

 

Any help on figuring this out would be appreciated !

 

Screenshot 2022-11-11 095608.pngScreenshot 2022-11-11 135749.png

Ok - if you have a valid link, are you trying to add this using Conditional Format WebURL?

Want to use a URL for your text column in Power BI Desktop? Check THIS out! - YouTube


I don't have a valid url for the non-MS Office docs it seems, unless I transform all the relative site URLs to work?

Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi @raman_vee  - using Power Query, I think you need to replace the " " with html codes (e.g. "%20" for space) and possibly add the ":u:/r" into the Path.  The URL will look like this:

 

https://abc.sharepoint.com/:u:/r/sites/tmnapevASSYae/projects/07/Library%20Name/File%20Name.txt

 

Note you can use this Power Query function to escape the string.  Uri.EscapeDataString - PowerQuery M | Microsoft Learn

I was able to get it working now, just be typing in a blank space, replaced the relativeURL with %20 and then modified the '/sites' to add in the http:// etc. each file works now, your suggestion was nearly correct but the u:/r:/ did not make it work. Thanks so much !

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors