Forum Discussion

telesforo1969's avatar
telesforo1969
Icon for Helper V rankHelper V
10 months ago

Create a date-time field from a date column and a number column with the time in "DirectQuery Mode"

  I need help joining two columns, one containing values ​​in date format and the other containing the time in number format in DirectQuery mode.  
Need Help
telesforo1969's avatar
telesforo1969
Icon for Helper V rankHelper V
10 months ago

I added an additional step because I had to change my hour period (1-24) to (0-23), but the format sets it as shown in the images. When I change it to integer type, it doesn't allow me.

 

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
10 months ago

Hi telesforo1969 ,

Thank you for your time and the update. In DirectQuery mode, changing data types or adding columns isn’t supported. It’s best to update your SQL source using DATEADD(HOUR, Hora - 1, Fecha) or switch to a Composite model and use DAX to create the DateTime column.

Hope this helps resolve the issue.

 

Regards,
Yugandhar.

  • telesforo1969's avatar
    telesforo1969
    Icon for Helper V rankHelper V
    10 months ago

    I understand. Thank you very much for the support, and I will consult with the database team about the possibility of adding the information.

    • V-yubandi-msft's avatar
      V-yubandi-msft
      Icon for Community Support rankCommunity Support
      10 months ago

      Sure, telesforo1969 . Once you connect with the database team , please let us know whether it’s possible or not. For further investigation, we’ll proceed based on the database team’s inputs.

       

      Thanks for staying engaged with the community.