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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors