Forum Discussion

yc-bsa's avatar
yc-bsa
Regular Visitor
4 years ago

Data Format Error: contain dash "-"

Hello all,  I am trying to load my data into Excel but have error with one of the columns (please see below).  I tried to put the data type as 'any' but still shows error. I tried using replace, bu...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi yc-bsa ,

 

Can you provide your M query please?

Select the query that you're having trouble with, open Advanced Editor and copy out everything in there and paste into a code window ( </> button) here. Remove sensitive items from the source step, such as file/server paths.

 

My guesses so far:

1) there may be a function later in your M code that is trying to convert this field back to a number.

2) the Excel destination may be preformatted as number type, so the error is throwing there rather than in Power Query.

 

Pete

yc-bsa's avatar
yc-bsa
Regular Visitor
4 years ago

Hi BA_Pete ,

 

Thanks for your reply. 

Do you need the full M Code from the beginning? Or the M code for the column that I am having trouble with? For the later, please see below:

<#"Changed Type2" = Table.TransformColumnTypes(#"Filtered Rows4",{{"Project", type text}})>
This is the last line of the codes and I am trying to export the query after this. 

 

Cheers