Forum Discussion

maserr's avatar
maserr
Helper IV
5 years ago

Web URL not clickable

Hi there,

 

I have set a data type on Analysis Services a field which is a Web URL. On Power BI when I use the field, it is set as Web URL but as it is not a measure, I cannot format conditioning this field to a web url.

 

How could this be possible?

 

Thanks

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    maserr If this is a DirectQuery/Live connection to Analysis Services it may not be possible. I assume that you are trying to set the Data Category on the column and it is greyed out?

    • maserr's avatar
      maserr
      Helper IV
      5 years ago

      Dear @Greg_Deckler,

      Exactly, I am using Live connection. The data type is set to text, that is greyed up but I also have set on SSAS that is a Web URL on the format field. Should I create a calculated column in order to achieve it?

      Thanks

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        maserr So this is greyed out? If so, create a measure like Measure = MAX('Table'[Web URL Column]) and set that to have a Data Category of Web URL.