bigint to date

[daouddajani]

is thier a way to convert bigint to dates in PowerBI

[MarcelBeug]

Bigint is not a supported data type in Power BI.

If you can import bigints in Power BI as a number, then you can converrt the number to a date field in Power Query.

[daouddajani]

They are only imported as bigint, for example

13415040 =

07/04/2013

the only way is to use the  system.dbo.tabula_dtoa which kills the cpu

[MarcelBeug]

Possibly you mean a UNIX timestamp?

I answered a question about that in this topic.