Forum Discussion
Date Hirachy SSAS Cube live connection
Hello, I am connecting Power-BI live to my SSAS Server where I have a date dimension. I tried different values for this dimension (e.g. '01-01-2014', '01.01.2014', etc) and its dimension attribut...
Hi mattk,
I can reproduce your issue. When we connect to the SSAS in live mode, the date type field will be treated as string, and we can’t change data type in live mode for fields. For this issue, I will report the issue internally and let you know if I get some feedback.
Regards,
Xiaoxin Sheng
Hi did you get any solution for this
- bpsearle
Resolver II
The answer seems to be to set the value property in Visual Studio for your date attribute in the dimesion. The value property needs to be date type in the underlying table. Have a look at this: https://community.powerbi.com/t5/Desktop/Cubes-SSAS-Date-Filters-and-PowerBI/td-p/43945
