Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi..
I need to import excel data which contains hyperlinks of files which is stored in local path to powerbi. So that I can access that hyperlinks from Powerbi.
Hi @AnilKumar
As of now, the hyperlinks of local files in Power BI have some limitations and don't work as you may expect. You can modify the file paths to have the prefix "file://" like below and mark this column as Web URL. It appears like hyperlinks. However when you click on any link in Power BI Desktop, it cannot open the file directly. When it is published to Power BI Service, it cannot directly open the file either. We can only copy the link and paste it into a tab of web browser to go to it.
There are some ideas about this feature, please help vote up for them.
Microsoft Idea · data category for local file (file://) (powerbi.com)
Reference:
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Thanks for your reply.
But I tried it, it is not working
The above link is not opening.
@AnilKumar , mark this column as a hyperlink in column property
refer
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
I don't want web url, i want local file path
C:\Users\tpriyanka\Documents\Defaultv7.pdf
Hi @AnilKumar ,
As you mentioned ,in power bi you cannot use the local path directly .
You can use below link for the reference:
You need to covert the images into the binary format, so you can use below code to covert:
let
BinaryToPbiImage = (BinaryContent as binary) as text=>
let
Base64 = "data:image/png;base64," & Binary.ToText(BinaryContent, BinaryEncoding.Base64)
in
Base64
in
BinaryToPbiImage
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Preeti
Hi @AnilKumar ,
You can simply import the excel file in power bi using the get data option -> Excel-> Load.
You will be able to access the link in power bi.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Preeti
@AnilKumar , Not hyperlink, but if columns contain URL you can import
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |