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
Rihab
Frequent Visitor

Create link for different types of files in powe bi

Hello , 

 

I am working on project to create report and the client wants to have links to files  that are sotred in sql server database . 
The files can be images , pdf files , docs, zip files etc .... 

is it possible to do that in power bi ( I think it's doable for pdf and images based on my research  ) 

thank you in advance and if I need to add more information so you can help me. Please let me know 

 

1 ACCEPTED SOLUTION

Hi @Rihab 

 

Currently, zip and doc cannot be recognized by Power BI.

As far as I know, Power BI can recognize these types:

vzhengdxumsft_0-1705973582406.png

You can create an HTML link to a specific cell in an excel file, this link may help:

Solved: html link to a specific cell in an excel file - Microsoft Fabric Community

 

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-zhengdxu-msft
Community Support
Community Support

Hi @Rihab 

If you want to link to an image in SQL Server in Power BI, you can try the following:

 

In Power BI, Get Data > SQL Server database

vzhengdxumsft_0-1705556711320.png

 

Then select the table where the image is stored

Then change the data type of the image column to text in the Power Query interface:

vzhengdxumsft_1-1705556711325.png

Then create a custom column and append a URL to let Power BI understand that it's an image

vzhengdxumsft_2-1705556722012.png

 

Close & apply

Then select the Data Category Image URL within the modeling tab

 

You can refer to this link for detailed steps:

How-to-use-Images-Stored-in-a-SQL-Server-Table-with-Power-BI

 

Of course, if your Image is in the form of a url, you can also try the following methods:

 

First of all, create a column using the URL of the image.

Then select the column and change the data category to Image URL above the Columns tool.

vzhengdxumsft_3-1705556738951.png

 

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much for the tutorials , I still have one question, if it is possible to create a link for documents ( xls, doc , zip) ? 

Hi @Rihab 

 

Currently, zip and doc cannot be recognized by Power BI.

As far as I know, Power BI can recognize these types:

vzhengdxumsft_0-1705973582406.png

You can create an HTML link to a specific cell in an excel file, this link may help:

Solved: html link to a specific cell in an excel file - Microsoft Fabric Community

 

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.