make URL clickable in live connection?

[mgcharumilind]

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?

[v-jiascu-msft]

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-tables

Best Regards!

Dale

[mgcharumilind]

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 · Accepted solution]

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 

[mahantesh1988]

In SSAS tabular data view.

Select the column,

Goto Properties

Reporting Properties

Data category

select webUrl.

[v-jiascu-msft]

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