Forum Discussion
Debugging Date Conversion Error
Hi jburklund ,
Whereabouts in your step list does this occur? Is there a specific step that triggers the error or is it immediately at Source/Navigation?
If it's after a certain step, then you may be able to select the step before it, go to the Home tab > Keep Rows > Keep Errors. You could also try inserting steps before the error steps that perform Clean and Trim functions on all of your columns from the Transform tab > Format > Trim/Clean.
If it's immediately on load, then I'd recommend running a query against your server, something like this:
//Column-by-column SELECT Col1 FROM yourTable WHERE Col1 like '%[^a-Z0-9]%'Re-run the query for each column in turn until you hit one (or more) that contains special characters.
Pete
Yes, you can create a new blank query, select SQL Server as source type then, when the database dialog comes up, enter you credentials and put your SQL query here:
Once you've run the query for one column, you can just hit the little cog next to the source step in Power Query. This will open this query window back up so you can just adjust the query for your new column(s).
Pete
Thank you! This should help me find the errors.