Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Dataflows sets data types incorrectly

In one of my entities, I have a column of type Date and a column of type Fixed Decimal Number. I have explicitly set the data types, and I can see the correct data type icons in column headers.

 

When I save and refresh my dataflow, then export the JSON file, the data types are set incorrectly to Date/Time (dateTime) and Decimal Number (double), respectively.

 

As a result, I have to set the data types again in Power BI Desktop.

Status: Accepted
Comments
Daniil
Kudo Kingpin

Apparently, the issue with date locales has now been fixed -- thank you!

 

The Time data type still does not work at all, and I'm hoping my idea will get some attention from the product team.

v-qiuyu-msft
Community Support

Hi @Daniil,

 

Glad to hear the issue is gone. Generally PG team will consider the idea in a high priority if there are too many votes on the idea. I already give one vote. Smiley Happy

 

Best Regards,
Qiuyun Yu 

Daniil
Kudo Kingpin

Thank you @v-qiuyu-msft Smiley Happy

pb1051
Advocate II

The double format is being set automatically for me in dataflows even though it shows as decimal in the service. When this data is in desktop it formats incorrectly. This should be resolved in a near future update.