Create a link to PDF on a server location

[Jerush]

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

[Jerush]

Hello Mike,

Thanks so much for the feddback and solution. We will give that a try.

Regards,

Jerusha

[MikeJohnsonZA · Accepted 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.