Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Data Format Error

Hello,   My dataset in the query editor shows no errors however when I close and apply my changes there is one error. There is no option to view the error from the first dialogue box and so when I ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    parry2k I've managed to solve now. It looks as though an error was created during earlier stages where I split a column, changed their formats and carried out some data cleansing, and re-merged them, changing their format a final time. Once these steps had been removed, the changes were applied without problem. 

    Thank you for your time and effort in helping

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous interesting, can you change the type of this column to text for the testing purpose and see if it loads correctly. Can you share M code here?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

parry2kI have ran the test as suggested and when I change this to text and "apply" I am greeted with the same error message as in my original post.

 

The M Code when selecting "keep errors" is as follows:

= Table.SelectRowsWithErrors(#"Filtered Rows3")

 

Apologies if this wasn't the M Code you were after if. If not, let me know which you are referring to and I will post.