Forum Discussion
Date import SSAS Cube live connection
In Power BI Desktop, when using live connection to SSAS, no matter what the format is defined in source cube, the date attributes is always resolved as text field. To use it as date field, you have to build a Date hierarchy in your source dimension. When you drag the date field within hierarchy into visual, the entire hierarchy will be displayed in visual.
In import mode, if the date column is in a proper format (like 2016/1/1, 2016-01-01), you should be able to convert it into a date type.
Regards,
thank you very much for your reply!
Do I undestand you correctly, that the date will still be shown as a text field when it is in a hierachy? I alreay tried putting it in a hierachy, but it is still veiwed as text. That means I cannot use visuals which only work with datetype data when I have a live connection to a SSAS cube? Also the filtering of a date (after a certain day, hour etc.) is not possible with a live connection?
Thank you,
Matthäus