Convert UNIX timestamp to DateTime using Direct Query

Hi, Anonymous 

There are some limitations and considerations when you use DirectQuery. No built-in date hierarchy:  When importing data, every date/datetime column will also have a built-in date hierarchy available by default. This built-in date hierarchy isn't available when using DirectQuery. If there's a Date table available in the underlying source, as is common in many data warehouses, then the DAX Time Intelligence functions can be used as normal. Date/time support only to second accuracy: When using time columns in your dataset, Power BI only issues queries to the underlying source to a level of detail of seconds. Queries aren't sent to the DirectQuery source for milliseconds. Remove this part of the times from your source columns.

For further information, please refer to the following links.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.