Forum Discussion

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

Date recognition in Power BI live connection to SSAS

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

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      ysapiyev
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

      Anonymous,

       

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        ysapiyev，

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


        Regards,
        Lydia