Forum Discussion

mkatipal's avatar
mkatipal
New Member
8 years ago

data type change analysis services

Hi, Am looking for ways to be able to change the data type of a Dimension attribute (like Resume number) from numerical to text data type. That will allow me to analyze some related facts. I dont s...
mkatipal's avatar
mkatipal
New Member
8 years ago

Is this applicable for Analysis Services as well?

I clicked Edit Queries option in the Home tab and I have only the Data Source Settings option available. Upon clicking that it goes to a window where i need to login to the model/data source

wwhittenton's avatar
wwhittenton
Helper II
8 years ago

I couldn't say for sure about Analysis Services.

 

When you go into Edit Queries, have you selected the table and column you would like to change the data type of?

  • mkatipal's avatar
    mkatipal
    New Member
    8 years ago

    This is all I see.

    Once I click the Data source Settings, It opens a window to enter Server name and Database name for Analysis services DB's

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

      Hi mkatipal,

       

      Your model is a live connection to SSAS that is also a powerful analysis tool. Since it's a live connection, you can't define or modify the model in the the Power BI side. You need to do it in the SSAS. Please refer to desktop-directquery-about/#live-connections.

       

      >>>However, unlike DirectQuery, there is no sense in which a new model is being created; in other words, it's not possible to define new calculated columns, hierarchies, relationships, and so on. Instead you are simply connecting directly to the external SSAS model.

       

      Best Regards,

      Dale