cancel
Showing results for 
Search instead for 
Did you mean: 
0

Dataflows - cannot set data type??

If I import an Excel spreadsheet into Dataflows, the date columns import as Text, and I cannot change the data type to Date. How can I do this please?

Status: Delivered
Comments
Moderator

@ansa_naz,

After adding entities in Power BI Service, you can edit entity and change data type of Date column to date as shown in the following screenshots.
0.PNG1.PNG

Regards,
Lydia

Moderator
Status changed to: Delivered