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
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.