Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |