Forum Discussion
When reading a folder the data type is automatically set in an inconvenient way
Hi all,
I have a folder of parquet files which I import in query editor. The parquet files all have the same columns/format so I can simply import all the parquet files in the folder. The files have a datetime column, which has the date in CET and another column with just the hour.
However, when I import all files in the folder, it automatically transforms my datetime CET column. You can see that it is not in line with the hour column anymore. The problem is that there is no "Changed Type" query step, since it uses the helper query because I import an entire folder and if I look at the helper query it simply shows the datetime CET column as datetime type without a "Changed Type" step (see second picture). It simply shows "source" and an already formatted datetime. I don't want to change the type afterwards since this can be problematic when a colleague opens this Pbix file from a different timezone?
How do I make sure that it does not automatically adjust the datetime column?
As of 20/06/2023. This does not appear to be possible in Power BI yet
2 Replies
- eurenergyFrequent Visitor
As of 20/06/2023. This does not appear to be possible in Power BI yet