cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Any way to render clickable hyperlink in a report?

Hello,

 

Is there any way to to add a calculated hyperlink column to my report, so when user click on the link , a browser instance pop up and shows a web page with more details? This idea would work very well with Dynamics CRM or SharePoint.

 

 

1 ACCEPTED SOLUTION
Responsive Resident
Responsive Resident

Via Power BI desktop i was able to formart a hyperlink i had stored in a table as a cliclable hyperlink data type. I was able to apply the same formating on a calculated column. 

 

 

Capture.JPG

Business Intelligence Architect / Consultant

View solution in original post

4 REPLIES 4
Regular Visitor

I am preparing a report using a datamodel that uses direct query (SQL), for me Data Category DDL is disabled.

 

In PowerBI Desktop, I can see only two sections,

1) Report - I see as below

ModelingTabFromReportView.PNG

 

2) Relationships  - I see as below

 

ModellingTabFromRelationshipsSection.PNG

 

Any Clue on how to enable HyperLink for a Column?

Hi,

 

Has anyone able to accomplish this .I also have the same issue as @KKakireported. I'm connecting to data from SQL Azure Database. Unable to find the option to enable hyperlink.

 

As suggested in the latest documentation here , this may not be possible unless the data coming from the database has urls. But I dont have urls in the data.

 

Additionally , I also want to call a Javascript function on click of this hyperlink. Is this possible. 

 

Thanks.

Responsive Resident
Responsive Resident

Via Power BI desktop i was able to formart a hyperlink i had stored in a table as a cliclable hyperlink data type. I was able to apply the same formating on a calculated column. 

 

 

Capture.JPG

Business Intelligence Architect / Consultant

View solution in original post

HI,

I am new at this Power BI thing, and I need some help somewhere along the same lines as the person who initiated this message.

I am pulling Data from SQL and one of teh columns is teh path and filename to a file on my P drive (P:\CD PDF\BAS\BAS 1234.pdf.

 

How can I add a new column that would apply formula "Hyperlink(Col1)" to all the records from my query?

 

I tried typing "CDPDFLink = concatenate(concatenate("=hyperlink(",[CDPDF]),")")" and while it doesn't fail, it did not make my data a clickable hyperlink.

I also change the column data type into weburl and that didn't work either.

 

Any thoughts on how to accomplish this?

 

Thank you,

 

Julia.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors