Date recognition in Power BI live connection to SSAS

[ysapiyev]

Hi everyone,

I have live connected SSAS cube to my Power BI model, and I faced an issue where slicer can't read date field as date. I looked for solution in community forums and stackoverflow and got answer that I should make "order by key". After I altered olap cube, Power BI didn't find it. I meant this:

What can be an issue?

Also, is there another way to change olap, so date will be recognized as date in Power BI?

Regards,

Yerkhan

[v-yuezhe-msft]

@ysapiyev,

"I have live connected SSAS cube to my Power BI model, and I faced an issue where slicer can't read date field as date"

Could you please post a screenshot about the above behavior ? What does the slicer look like in Power BI Desktop? 

Regards,
Lydia

[ysapiyev]

@v-yuezhe-msft,

Here what my slicer is look like:

Date is recognized as string, in my custom visuals, I parsed it from string. However, in slicer, I was not able to do so.

Regards,

Yerkhan

[v-yuezhe-msft]

@ysapiyev，

Check my date slicer in SSAS live connection, you should have a similar Date.Value.


Regards,
Lydia

[ysapiyev]

@v-yuezhe-msft,

Thanks for reply. I don't have value field in my SSAS. What can be an issue?

Regards,

Yerkhan

[v-yuezhe-msft · Accepted solution]

@ysapiyev,

There is an issue about your date dimension in SSAS, please review this similar thread about how to define date dimension  in SSAS.

Regards,
Lydia

[ysapiyev]

@v-yuezhe-msft,

Thanks!