Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape 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.

Reply
Jerush
Helper I
Helper I

Create a link to PDF on a server location

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

1 ACCEPTED SOLUTION
MikeJohnsonZA
Responsive Resident
Responsive Resident

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.

 

 

View solution in original post

2 REPLIES 2
Jerush
Helper I
Helper I

Hello Mike,

 

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

Regards,

Jerusha

MikeJohnsonZA
Responsive Resident
Responsive Resident

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.

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.