Forum Discussion

Community Champion

7 years ago

Dataflow type inconsistency / bug

This is a bug report. I just set up a dataflow that has a Date column, yet Power BI Desktop loads that column as DateTime (yes I checked that there's no auto transformation of the data type in PQ on ...

General Comment

sebadb9

Kudo Collector

7 years ago

Hi Otravers, I'm having the exact same issue!

yaronc
Power BI Team
7 years ago
Hi sebadb9, otravers,

Thanks for reporting on this one.

We are investigating this issue.

As a workaround you can change in Power BI Desktop the data-type again to Date.

Thanks,

Yaron
- sebadb9
  Kudo Collector
  7 years ago
  for your information otravers
  
  https://community.powerbi.com/t5/Issues/Dataflow-preview-dd-mm-yyyy-becomes-mm-dd-yyyy-when-consuming/idi-p/562330/page/2#comments
  
  https://community.powerbi.com/t5/Issues/Dataflows-UK-US-Date-Format/idc-p/572272/highlight/true#M35351

Forum Discussion

Dataflow type inconsistency / bug

Related content

Data format inconsistent between table in source dataflow and linked dataflow

Dataflows being inconsistent (Business Central data)

dataflow gen1

Fabric Dataflow Gen 2

Type Mismatch