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

Hi telesforo1969 ,

Thank you for testing, you're doing a good job exploring different solutions. You’re correct if the [Hora] column contains just a number, the DAX formula may default to 12:00:00, which is not the intended result.

To resolve this, we should adjust the formula to match the format of your [Hora] column. Here are a few options based on how your data is set up.
1. If [Hora] is a whole number

DateTime = 
'Table'[Fecha] + TIME(INT('Table'[Hora]), 0, 0)

2. If [Hora]  is already in time format

DateTime = 
'Table'[Fecha] + 'Table'[Hora]

 3.If [Hora] includes decimals

DateTime = 
'Table'[Fecha] + TIME(INT('Table'[Hora]), MOD('Table'[Hora]*60, 60), 0)

Try and Let me know how your [Hora] column is set up whether it's an integer, decimal, or actual time. You’re really close to getting this working smoothly.

Regards,
Yugandhar.