Forum Discussion
Power BI is not returning same date as Power BI Query editor
In Power Query I am able to see date as 12/31/1899 however in Power BI report I am able to see it as 2/6/2036 . Expected date is 12/31/1899 as in the backend its same. Power Query Power BI...
Thank you !
Issue is resolved! column was in Date time format due to which PBI was not able to store it properly as for every date it will convert into decimal.
I changed the format to Date in query editor after which it start showing correct data in PBI report view as well.