Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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?

 

Need Help

5 Replies

  • mahantesh1988's avatar
    mahantesh1988
    Frequent Visitor
    9 years ago

    In SSAS tabular data view.

    Select the column,

    Goto Properties

    Reporting Properties

    Data category

    select webUrl.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    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