Forum Discussion
Power BI dataflows and date/time columns error
I have a SQL database that contains datetime columns in some of the tables. The locale of the server is NZ English so the datetimes come through as 15/01/2020, 12:00:00 am This comes through fine...
I finally figured the workaround to this issue.
In the dataflow entity editor (Power Query) Home ribbon, go Options -> Project ptions and choose English (United Kingdom) from the Locale drop down. It was defaulted to English (New Zealand).
I finally figured the workaround to this issue.
In the dataflow entity editor (Power Query) Home ribbon, go Options -> Project ptions and choose English (United Kingdom) from the Locale drop down. It was defaulted to English (New Zealand).
Hi Anonymous ,
If you solved the issue, please accept your own reply as the solution.
More people will benefit from it.
Best Regards,
Stephen Tao