cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

how to change data type text to date in power BI DataFlow

Hi There,

 

 

While creating DataFlow in web Power BI, i am trying to changing the Date type text to Date and error are appears 

 

before this folowing steps are applied in query editor

 

1) Source

2) Filtered Rows with file name from folder (

3)Split by space (Eveiry Excel file has name with Date in MM/DD/YYYY format hence splited with right most space option)

 

after above steps i am trying tochange date type text to date type but facing error.

 

 

 

Please guideDataFlow error.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how to change data type text to date in power BI DataFlow

Hi @Amardeep100115 ,

Based on my research, you could try to modify the advanced editor in dataflow:

1.PNG

2.PNG

Regards,

Daniel He

 

 

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
bwsutton1990 Frequent Visitor
Frequent Visitor

Re: how to change data type text to date in power BI DataFlow

Hi

 

If you create a new column and use DATEVALUE, do you get the same error?

 

If so, it is likely to be a configuration issue within dates i.e. you config specifies DD/MM rather than MM/DD.

 

 

Thanks

Re: how to change data type text to date in power BI DataFlow

Which option i have to use and how?DataFlow error 1.JPG

Community Support Team
Community Support Team

Re: how to change data type text to date in power BI DataFlow

Hi @Amardeep100115 ,

Based on my research, you could try to modify the advanced editor in dataflow:

1.PNG

2.PNG

Regards,

Daniel He

 

 

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.