Add column creation date

Hi,

I use Power BI to make reports from a databse with ODBC link.

In my database, each field has a creation date, but power BI doesn't show it as a column.

I need to display a column showing the creation time of each record, to be able to create another one with hour ranges, to analyze my records on hour ranges (morning, noon, afternoon, evening).

My IT manager says to use a querry : extract(hour from (audit).createtime) but I don't see how to use it with power bi.

Can anybody help ?

Thanks