Hyperlinks from excel to Powerbi

[AnilKumar]

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.

[v-jingzhang]

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  · Open local files (file://) directly by click on url link as with (http://) (powerb...

Microsoft Idea  · data category for local file (file://) (powerbi.com)

Reference:

Supported link types

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[AnilKumar]

Thanks for your reply.

But I tried it, it is not working

The above link is not opening.

[amitchandak]

@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

[AnilKumar]

I don't want web url, i want local file path 

C:\Users\tpriyanka\Documents\Defaultv7.pdf

[Preeti_Yadav]

Hi @AnilKumar ,

As you mentioned ,in power bi you cannot use the local path directly .

You can use below link for the reference:

 https://youtu.be/A-Ytgs6p0aY 

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

[Preeti_Yadav]

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

[amitchandak]

@AnilKumar , Not hyperlink, but if columns contain URL you can import