Forum Discussion

daouddajani's avatar
daouddajani
New Member
9 years ago

bigint to date

is thier a way to convert bigint to dates in PowerBI

 

 

3 Replies

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion

    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's avatar
      daouddajani
      New Member

      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