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

Problem with error handling and dates

Hi everybody!

 

I currently have some dates with the day with "00", let-s say, the sources does not have idea about the day so it is reported as 00. So some of the dates are 00-08-2019. As the column is recognized as a date, those values are reported as a cero. 

 

I find the same situation in other columns, but, it they are not recognized as dates, i have the time to replace -00 for -01 and then change it to date format, and i still keep those values!

 

What can I do for the power query editor to leave the original values for me to able to change them before finding errors? (I have already tried to unclick the option to recognize the data type, but i has not worked so far). 

 

I do not know if i explain mayself in a good way... I hope you guys understand. Thank you in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Problem with error handling and dates

Hi @lgo ,

you have 2 choices:

 

1) remove the automatically created changed step manually by clicking the cross

2) manually edit the automatically created M code and delete only the column whose formatting you want to skip:

 

image.png

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




4 REPLIES 4
Super User
Super User

Re: Problem with error handling and dates

Hi @lgo ,

you have 2 choices:

 

1) remove the automatically created changed step manually by clicking the cross

2) manually edit the automatically created M code and delete only the column whose formatting you want to skip:

 

image.png

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




lgo Frequent Visitor
Frequent Visitor

Re: Problem with error handling and dates

Thank you so much for your reply! but i can't see the same in my screen!

 

Capture.PNG

lgo Frequent Visitor
Frequent Visitor

Re: Problem with error handling and dates

So I have discovered something further....

 

I have all the tables without Data types in the columns...when I do merge + then expand = some columns got the Data type! Do you know why this is happening?

 

Thank in advance,

 

Laura.

Super User
Super User

Re: Problem with error handling and dates

Hi Laura,

you have to enable the Formula Bar in the View-Tab like so:

 

image.png

 

You should check the Source-queries (the current one and the ones you're merging). Fix the corrections you want to make there before merging.

Usually you loose your types during merge/expand-operations. This is a known limitation.

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 297 members 3,577 guests
Please welcome our newest community members: