Date import from SSAS cube

[ysapiyev]

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 source?

Regards,

Yerkhan

[Phil_Seamark]

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]

@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

[ysapiyev]

Hi everyone,

I have SSAS multidimensional cube as data source with live connection. I faced two problems:

1. Slicer can't read date field in my data as date.

2. All data recognized as Power BI measures, not fields. Therefore, I can't use data aggregation in visuals.

How it can be solved?

Regards,

Yerkhan