Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Unusual Behavior for Dates

I have unsual behavior involving dates. I have made a slicer based on date, it's working perfectly fine in Power BI Desktop:     But once I uploaded it on the Power BI Service, The dates are...
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

Please right click the "Query Edit", and see if there is "Canged Type".




In addition, connect directly to the SAP HAHA data source using DirectQuery, which may caused the error.

Thanks,
Angelia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hello Angelia!

 

There is no Changed Type found. Also, I am already using Direct Query using SQL Statement 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Anonymous,

    In Power Query Editor navigator, you try to change it to date type like the following screenshot.



    Best Regards,
    Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hello Angelia!

       

      I have done that also but the issue is still the same. I was thinking if there is a support that I could raise this issue for a demo? just to iron out all the possibilities...