Forum Discussion
mkatipal
8 years agoNew Member
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
8 years agoNew Member
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
8 years agoMicrosoft Employee
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