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
Microsoft Employee
9 years ago

Hi Anonymous,

I am unable to reproduce your scenario, whether or not this issue always happens for other data resource? You create a simple date table by "Enter Data" under Power BI desktop home page, then publish it to service for test.

Thanks,
Angelia

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