Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Error Message

Hi,

 

I import data from a folder with many excel files in it. I just added a singular column to all of the excel sheets in the excel files and now it is giving me this error message. What did I do wrong?

 

cnormand_1-1594315233986.png

 

1 ACCEPTED SOLUTION

@Anonymous ,

 

Probably that's why you got this error.

 

You can see the m code on:

 

Query Editor -> Home -> Advanced Editor

 

There is the generated code for all steps applied on your query.

 

Power Query starts handling excel file with generical names like "Column1...Column2.." and after that it types based on the preview values.

 

If you create a new column in the middle and the datatype is different from the previous expected, you get a error.

 

Check it changing this new column to the last column and see if you still get this error.



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

Proud to be a Super User!



View solution in original post

9 REPLIES 9
camargos88
Community Champion
Community Champion

@Anonymous ,

 

Have you changed the order ? Also paste the m code here.



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

Proud to be a Super User!



Anonymous
Not applicable

I put the column in the middle of the colums, but all in the same locations across all of the sheets. Where do I find the m code? @camargos88 

aj1973
Community Champion
Community Champion

Hi @Anonymous 

In Power Query/ Query settings / Applied steps, there is a step that needs to be deleted of one of your tables.

Once deleted re do your steps.

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

@aj1973 

 

I tried deleting all of my steps and the error went away but then when I tried to apply it, it would give me another error.

 

@Anonymous ,

 

Probably that's why you got this error.

 

You can see the m code on:

 

Query Editor -> Home -> Advanced Editor

 

There is the generated code for all steps applied on your query.

 

Power Query starts handling excel file with generical names like "Column1...Column2.." and after that it types based on the preview values.

 

If you create a new column in the middle and the datatype is different from the previous expected, you get a error.

 

Check it changing this new column to the last column and see if you still get this error.



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

Proud to be a Super User!



Anonymous
Not applicable

@camargos88 

 

Here is the code.

cnormand_0-1594317328922.png

 

@Anonymous ,

 

Could you change the order in the file ?



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

Proud to be a Super User!



Anonymous
Not applicable

@camargos88 @aj1973 

 

Thank you both very much. I ended up moving the column to the end, while also deleting all the steps in the query editor. Even though I had to re-do some calculations I had previosley made, it works now!

Anonymous
Not applicable

@camargos88 

 

I think I am going to do that now and see if it works. I will let you know. Thank you!

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.