Data Model Duplicating Column and Appends 1 to Header

[ncitrin]

I'm appending two different tables in power query. The resulting table shows 1 column, but once it goes into the data model it splits into two separate columns and appends a 1 to the end of the header.

I've attached a screenshot with the column names highlighted that are of issue.

zAssemblyVsComponent and zNewVsReman 

How do I remedy this issue?

 

[ncitrin]

We took your advice and it helped solve the problem. Thanks again for your help!

[jennratten · Accepted solution]

Hello - the screenshot you provied looks to be from Power Pivot in Excel.  I have seen the scenario you described occur when a table is loaded to the Power Pivot data model, another table is created in Power Query that has the same name (perhaps the old table was renamed or removed and recreated) and then the new table is also loaded to the data model.  The reason why another table appears in your list with a 1 at the end is because a second table with the same name was loaded to the data model.  To remedy this issue you can unload the tables from the data model and then reload the correct table.  Just be sure to make note of any measures/calculated columns that you have added to that table before unloading it, so you can add them back.  To prevent this from occurring, if you are replacing a table in Power Pivot, you will either need to replace the contents of the same table in Power Query that is loaded to the data model, or unload the original table before loading the new table.

[ncitrin]

Yes, this is Power Pivot. Had to step away from the model, but what you're saying makes sense. I'm going to test it as soon as get back to the model and will report back on the forum. Thank you for your help!

[jennratten]

You're welcome!