Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Analyze in Excel causes problems with date types

Hello,

 

My dates in power bi desktop work perfectly, same with reports online or when you export the data from power BI to excel.

However when trying when connecting excel with power bi (power bi analyze in excel), dates are not recognized at all (it offers dates like if they were text, sort A to Z).

I tried to put my computer in English US but issues continues. I have looked online quite a lot but have not seen solutions for this.

Does anyone encountered this and found a solution?

 

Thank you,

 

Raphaël

Need Help

6 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Raphaël,

     

    Seems good in my test. Can you share some snapshots?

    Analyze_in_Excel_causes_problems_with_date_types

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

       

      Like you can see I can only sort date A to Z and not by date.

      I have tried to change my whole windows and excel in english usa but does not do the trick either.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Anonymous,

         

        I have reported this issue to the Product Team: CRI 77356488. I will update here when I get responses.

         

        Best Regards,

        Dale