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...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

 

Hello Angelia!

 

Thanks a lot for taking a look into this, I was unable to replicate this to other data source. Curiously, I don't have problems when I am using the Import option from SAP HANA. This happens when I am using DirectQuery on SAP HANA with SQL Statement and I was using some date functions being used in the SQL query to convert the data (initially it's not in date format, in whole number but I need to convert it to date) :

 

 Everything is working fine in Desktop.

Sample: select to_timestamp(to_timestamp(<column with whole number data type>), 'YYYY-MM-DD HH24:MI:SS.FF7') from <view>

 

In Power BI Service, it's not working anymore:

 

 

 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft 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
      Microsoft 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...