Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I want to create a report based on a SQL query, and one of the columns would be a path to a PDF document that resides somewhere on a server.
So it would look like \\myserver\myfolder\myfile.PDF
I followed the steps as per https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables, but that doesnt work as I read that the URL needs to be in a certain format.. https:, FTP:, etc.
Is there anyway then to convert a file path on the server into a URL link, so that a user can click on it and it would open, even in a web browser.
Thank you
Jerusha
Solved! Go to Solution.
Hi, this is not really a Power Query question(Totally fine) but yes you can do this by setting up a web server.
If you are using windows the easiest would be to use IIS(Apache if Linux), I found a setup blog (Build a Static Website on IIS | Microsoft Docs) once setup you can create a site to map the same folders and you will be able to add those links using an HTTP url.
Hello Mike,
Thanks so much for the feddback and solution. We will give that a try.
Regards,
Jerusha
Hi, this is not really a Power Query question(Totally fine) but yes you can do this by setting up a web server.
If you are using windows the easiest would be to use IIS(Apache if Linux), I found a setup blog (Build a Static Website on IIS | Microsoft Docs) once setup you can create a site to map the same folders and you will be able to add those links using an HTTP url.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
94 | |
89 | |
32 | |
28 |