Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AnilKumar
Helper II
Helper II

Hyperlinks 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.

7 REPLIES 7
v-jingzhang
Community Support
Community Support

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.  

083001.jpg 

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
Helper II
Helper II

Thanks for your reply.

But I tried it, it is not working

AnilKumar_0-1629960390135.png

The above link is not opening.

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:

 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
Resolver I
Resolver I

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
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.