Forum Discussion

eurenergy's avatar
eurenergy
Frequent Visitor
3 years ago
Solved

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

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion

    Hi eurenergy in your picture there is no visible datatype values to see details. Still, it there is something  like datatype datetime or whatever you can simply overwrite it with your datatype to like datatype date. I hope this help

  • eurenergy's avatar
    eurenergy
    Frequent Visitor

    As of 20/06/2023. This does not appear to be possible in Power BI yet