Reply
Regular Visitor
Posts: 36
Registered: ‎07-10-2017
Accepted Solution

make URL clickable in live connection?

I am using a live connection to a Cube database in Analysis Services where my table has a field that includes URLs. I want to display these links (probably in a table) in my report as live/clickable rather than a text string. However, I can't set this in Power BI via the model, given that it is a live connection. It doesn't appear that adding HTML tags is going to do the trick, and I can't find any DAX functions that will allow me to do this as a measure. What can I do, either in Desktop or in the Service?

 


Accepted Solutions
Community Support Team
Posts: 7,650
Registered: ‎05-02-2017

Re: make URL clickable in live connection?

Hi @mgcharumilind,

 

I have tested the connection to SSAS cube. It seems this should define in the cube. This video could help, please have a try. https://www.youtube.com/watch?v=ywaTxQKchx8

 

Best Regards!

Dale 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 7,650
Registered: ‎05-02-2017

Re: make URL clickable in live connection?

Hi @mgcharumilind,

 

You can try this.

In Power BI Desktop. Modeling -> Data Category (Web URL). Publish it to Service if you want to use it in the Power BI Service.

NOTE: The URLS must start with http:// , https:// or www.

Please reference: powerbi-service-hyperlinks-in-tablesmake URL clickable in live connection.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor
Posts: 36
Registered: ‎07-10-2017

Re: make URL clickable in live connection?

Thanks Dale, but there isn't any Modeling tab in the Live Connection to our Cube in Analysis Services. I have read that article several times wishign that it had my solution, but it only details Direct Query and Imported data. Hence my conundrum.

Community Support Team
Posts: 7,650
Registered: ‎05-02-2017

Re: make URL clickable in live connection?

Hi @mgcharumilind,

 

I have tested the connection to SSAS cube. It seems this should define in the cube. This video could help, please have a try. https://www.youtube.com/watch?v=ywaTxQKchx8

 

Best Regards!

Dale 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor
Posts: 5
Registered: ‎08-18-2016

Re: make URL clickable in live connection?

In SSAS tabular data view.

Select the column,

Goto Properties

Reporting Properties

Data category

select webUrl.

Community Support Team
Posts: 7,650
Registered: ‎05-02-2017

Re: make URL clickable in live connection?

Hi @mgcharumilind,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a help to the others.

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.