Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Image URL does not work!! Data category is not enabled in LIVE connnection?

Hi All,   Greetings,   I am in believe now that Data categorization does not go along with LIVE connection. can anyone came across this thing, any help is highly appreciated. I want to dispplay ...
Need Help
quentin_vigne's avatar
quentin_vigne
Icon for Solution Sage rankSolution Sage
8 years ago

Anonymous

 

That's very very strange, because I tried to connect to my database on my side with Direct Query, and I have all the options to create a new column ...

 

 

 

- Quentin

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ohh!!

 

Not sure why is that. I am using SQL server Analysis services and using 'Connect LIve'.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-piga-msft,

     

    Actually I am just writing a DAX measure for this operation. Like-:

     

    SampleMeasure = If(A>B),image1URL

                                  If(A<C),image2URL

                                  ,image3URL;

     

    So that means this column we just need at report level and it will be made in report only after pulling the data from model/cube. What to do in this situation? I am all tied up.

     

    Regards,

    Droid

  • quentin_vigne's avatar
    quentin_vigne
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Anonymous

     

    You are connected to your model.

    Live Connection refers to connecting directly to a Model (SSAS Multidimensional or Tabular)

    With Direct Query - you are connecting to a database, and you have the ability to create calculated columns and measures in Power BI

     

     

    Maybe you can change your access and connect to data instead of your model ? Else you will have to add everything you need in your model and not on PowerBI ...

     

    - Quentin

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I agree. But that is the requirement, i have to use Model only becuase that is already being created and we have to deploy a dashbaord based out of that Model.

     

    any other suggestions or Is there any custom visual which can fulfill this task?

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi Anonymous，

     

    You could change the data category to be ImageURl in SSAS site, then when you have a live connection with SSAS, the image should be  shown in the report.

     

    I have found this video which should help you.

     

    Hope this can help you!

     

    Best Regards,

    Cherry

  • amnda_andrade's avatar
    amnda_andrade
    New Member
    2 years ago

    Hello v-piga-msft 

     

    I had the same issue you had you can quickly correct it just changing the measure data type to "text" than the data category "image url" should appear

     

    Hope it helps