Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
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 !
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 !
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?
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 !
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |