Forum Discussion

andyor's avatar
andyor
Resolver I
3 years ago

Direct Query with Date parameters

I am using DQ mode to query a basic table on TransactionDate. The issue is that the database times are UTC time, but the server is in local time. For this purpose, a function ufnToUTCTime() is called...
Need Help
andyor's avatar
andyor
Resolver I
3 years ago

Thanks but don't think this will work as I need to use a database function ufnToUtcTime(), which converts the local time (server) to UTC time (database)

  • andyor's avatar
    andyor
    Resolver I
    3 years ago

    unless power BI has some inbuilt function that can do the same? (convert to UTC time)