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
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
Solved! Go to Solution.
Hi @Rihab
Currently, zip and doc cannot be recognized by Power BI.
As far as I know, Power BI can recognize these types:
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.
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
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:
Then create a custom column and append a URL to let Power BI understand that it's an image
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.
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:
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |