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

 

If you right click on a table you should have the option to create a column

 

- Quentin

Anonymous's avatar
Anonymous
Not applicable
8 years ago

No. I am not getting that option.

 

 

  • 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'.

       

       

      • 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