cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mgcharumilind Regular Visitor
Regular Visitor

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-jiascu-msft Super Contributor
Super Contributor

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.
5 REPLIES 5
v-jiascu-msft Super Contributor
Super Contributor

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.
mgcharumilind Regular Visitor
Regular Visitor

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.

v-jiascu-msft Super Contributor
Super Contributor

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
mahantesh1988 Frequent Visitor
Frequent Visitor

Re: make URL clickable in live connection?

In SSAS tabular data view.

Select the column,

Goto Properties

Reporting Properties

Data category

select webUrl.

v-jiascu-msft Super Contributor
Super Contributor

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.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 332 members 3,434 guests
Please welcome our newest community members: