Forum Discussion
Cannot change data type to date
NAV System one table have two date column: shipment date and posting date , I can change shipment date to date type, cannot change posting date to date type, I need date hierarchy for posting date, w...
Please post some sample data for us to assist. The answer to you question will be hidden in the data you are working with.
Please post some sample data for us to assist. The answer to you question will be hidden in the data you are working with.
Mine changes half the data type to date, whilst the other half of the rows display the word "error" where the "date" should have been displayed. The Power Query Editor in Power BI Desktop seems to have a bug!
The same data source does work fine in Office 2016 Professional Plus - when using the Power Query Editor. Power Pivot features work well in Excel. It is possible that the Power BI Desktop / Power Query Editor - might have an issue.