- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
05-06-2024 02:04 PM | |||
Anonymous
| 03-01-2018 06:24 PM | ||
12-23-2016 12:46 PM | |||
06-25-2024 02:02 AM | |||
06-21-2024 02:12 PM |