Forum Discussion

mattk's avatar
mattk
New Member
10 years ago

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 attribute type in Visual Studio is set to "Date". In Power-BI it is not recognized as a Date, since I can not filter it like I can filter dates imported from an excel...

 

What are my options to import a date from a live connection to a cube? Does it have to be a special format?

 

Thanks for the help,

Matthäus Kerres

 

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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

  • koushikB's avatar
    koushikB
    Frequent Visitor
    9 years ago

    One thing is for sure you cannot import the date from excel. Please check with this format 01/29/2017.