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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi tomq04,

I am not able to reproduce your issue in your PBIX file, please check the following screenshot. Do you use the latest version of Power BI Desktop?



Thanks,
Lydia Zhang

tomq04's avatar
tomq04
Helper I
9 years ago

Hi Lydia,

 

You are correct this functionality works when imported.  After talking with a technician we determined that we needed to create an idea ticket for the functionality to work with Direct Query with a Redshift data source.