Forum Discussion

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive Resident
8 years ago

Date import from SSAS cube

Hi everyone,   I have SSAS cube with live connection as data source, and I have date input. However, slicer does not recognize it as date. How it can be fixed? What data type should be in SSAS sour...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ysapiyev

 

What is the underlying datatype of the date column in the SSAS cube?  I assume this is a multidimensional cube?

 

Often the MDX model uses a couple of columns for an attribute.  A common scenario in the MDX world is to use Integer values for the Key and a text value for the Name.  Neither of these will be picked up as dates in Power BI.  Ideally you should expose a date for both the key and name - for the purpose of Power BI.  Do you have the ability to modify the SSAS cube?

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive Resident
8 years ago

Phil_Seamark.

 

It is multidimensional cube.

 

In SSAS cube, date is recognized by Power BI as hierarchy. I have an ability to modify it.

Also, by any chance, did you face the issue that all data in cube is recognized as Power BI measures by Power BI, not fields?

 

Regards,

Yerkhan