Power Query Adding Hours to DateTime

[Anonymous]

I have a column which can be queried in any SQL tool, and show a value in the first row of 5:00:00, for example, in DateTime format.
If I query that same column, and perform no additional steps or transformations, it is giving me a value of 9:00:00 in the first row. If I then format this column to text, it will show me the expected value of 5:00:00. If I add a separate step to format in DateTime, it will remain at the expected value of 5:00:00.

Is this an expected functionality of Power Query in Power BI?

[Anonymous]

Hi @Anonymous 

I don't quite understand your needs, can you explain your problem with a real case? It can be in the form of screenshots or videos.

Best Regards,
Community Support Team _ Ailsa Tao

[Anonymous]

Here is my scenario: 

TableName[DateTimeColumn] queried in any SQL tool outside of Power BI:

ROW_ID	DateTimeColumn
123	5:00:00

That value is correct and the expected value. Now if I query that same table and column into Power BI, it gives me a DateTime value with +4 hours:

ROW_ID	DateTimeColumn
123	9:00:00

If I convert that DateTime column in Power Query to text, it then gives me the expected/correct value of 5:00:00.