cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Error Message

@cnormand ,

 

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!
Ricardo

View solution in original post

9 REPLIES 9
Highlighted
Community Champion
Community Champion

Re: Error Message

@cnormand ,

 

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


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

Highlighted
Helper III
Helper III

Re: Error Message

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 

Highlighted
Community Champion
Community Champion

Re: Error Message

@cnormand ,

 

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!
Ricardo

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Error Message

Hi @cnormand 

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
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

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

Re: Error Message

@camargos88 

 

Here is the code.

cnormand_0-1594317328922.png

 

Highlighted
Community Champion
Community Champion

Re: Error Message

@cnormand ,

 

Could you change the order in the file ?


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

Highlighted
Helper III
Helper III

Re: Error Message

@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.

 

Highlighted
Helper III
Helper III

Re: Error Message

@camargos88 

 

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

 

Highlighted
Helper III
Helper III

Re: Error Message

@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!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors