Forum Discussion
AnilKumar
Helper II
Helper IIHyperlinks from excel to Powerbi
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.
amitchandak
Super User
Super UserAnilKumar , 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
AnilKumarHelper II
Helper III don't want web url, i want local file path
C:\Users\tpriyanka\Documents\Defaultv7.pdf
Preeti_YadavResolver I
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
BinaryToPbiImageDid I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Preeti