Forum Discussion

tomq04's avatar
tomq04
Helper I
9 years ago
Solved

Adding/Subtracting Hours from a date from Redshift Source using DAX

I'm currently trying to subtract 8 hours from a date/time stamp hosted in Redshift.  This function works just fine when conntected to a SQL Server source (using literally the same table) but it is on...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi tomq04,

    Could you please use import mode to upload some records of data from Redshift to Power BI Desktop, then check if the issue persists?

    Thanks,
    Lydia Zhang

tomq04's avatar
tomq04
Helper I
9 years ago

We are using direct query, the table we are working with is >15mm records.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi tomq04,

Could you please use import mode to upload some records of data from Redshift to Power BI Desktop, then check if the issue persists?

Thanks,
Lydia Zhang

  • tomq04's avatar
    tomq04
    Helper I
    9 years ago

    Hi Anonymous

     

    Even after importing the data we are still having the same issue where only 29 seconds is being subtracted from the date.

     

    Screenshot

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi tomq04,

      Could you please share me the PBIX file which you use import mode to connect to Redshift?

      Thanks,
      Lydia Zhang

      • tomq04's avatar
        tomq04
        Helper I
        9 years ago

        I sent you a private message with the onedrive link.  Let me know if that does not work.

         

        Thanks