Forum Discussion

mattk's avatar
mattk
New Member
10 years ago

Date import SSAS Cube live connection

Hello,   I am connecting live to a SSAS cube with Power-BI desktop (version July 2016). In the cube I created a dimension containing a date (tried different formats like: 2014-01-01, 2014.01.01, 01...
Habib's avatar
Habib
Icon for Continued Contributor rankContinued Contributor
10 years ago

You need to fix the date format in Cube. Also, i you want to use hierarchy as you mentioned in excel, you need to create that hierarchy in Cube. Your date will start beaving according to that hierarchy.

 

In live connection, you can't play arround with data in Power BI.