Forum Discussion

New Member

9 years ago

bigint to date

is thier a way to convert bigint to dates in PowerBI

Community Champion

9 years ago

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.

New Member

9 years ago

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