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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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