XML Mapping doesn't seem to work with my table

%3CLINGO-SUB%20id%3D%22lingo-sub-3384222%22%20slang%3D%22en-US%22%3EXML%20Mapping%20doesn't%20seem%20to%20work%20with%20my%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3384222%22%20slang%3D%22en-US%22%3E%3CP%3EBackground%3C%2FP%3E%3CP%3EI'm%20working%20with%20Configuration%20Packages%20in%20Business%20Central.%20I%20downloaded%20the%20Excel%20workbook%20provided%20by%20Business%20Central%20to%20use%20for%20my%20data%20import.%20It's%20got%20all%20my%20columns%20that%20I%20need%20and%20behind%20the%20scenes%20there%20is%20an%20XML%20Map.%20I%20exported%20this%20map%20so%20I%20could%20use%20it%20later.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20another%20spreadsheet%2C%20I%20started%20with%20some%20raw%20sales%20data.%20Using%20a%20combo%20of%20Power%20Query%20and%20Power%20Pivot%2C%20I%20was%20able%20to%20create%20the%20final%20data%20output%20I%20need.%20I%20saved%20and%20loaded%20the%20resulting%20Query%20to%20a%20table%20on%20its%20own%20sheet.%20The%20problem%20I'm%20running%20into%20is%20when%20I%20try%20to%20import%20my%20XML%20Schema%20file%20that%20I%20mentioned%20above.%20When%20I%20import%20it%2C%20everything%20works%20fine%2C%20but%20when%20I%20drag%20and%20drop%20the%20elements%20onto%20my%20table%2C%20I%20get%20the%20following%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%22The%20operation%20cannot%20be%20completed%20because%20the%20result%20would%20overlap%20an%20external%20data%20range%20or%20PivotTable%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhat%20I%20expected%20to%20happen%20was%20that%20it%20would%20remap%20the%20data%20just%20like%20I%20see%20in%20this%20video.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DjmJFe3IV62s%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EMapping%20and%20importing%2Fexporting%20an%20XML%20schema%20with%20Excel.%20-%20YouTube%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EMy%20end%20goal%20is%20to%20produce%20a%20workbook%20that%20processes%20our%20raw%20sales%20data%20into%20the%20correct%20format%2C%20copy%20the%20tab%20with%20the%20final%20data%20to%20a%20new%20workbook%20and%20then%20import%20to%20Business%20Central%20with%20a%20Configuration%20package.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3384222%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Background

I'm working with Configuration Packages in Business Central. I downloaded the Excel workbook provided by Business Central to use for my data import. It's got all my columns that I need and behind the scenes there is an XML Map. I exported this map so I could use it later.

 

In another spreadsheet, I started with some raw sales data. Using a combo of Power Query and Power Pivot, I was able to create the final data output I need. I saved and loaded the resulting Query to a table on its own sheet. The problem I'm running into is when I try to import my XML Schema file that I mentioned above. When I import it, everything works fine, but when I drag and drop the elements onto my table, I get the following error.

 

"The operation cannot be completed because the result would overlap an external data range or PivotTable"

 

What I expected to happen was that it would remap the data just like I see in this video.

Mapping and importing/exporting an XML schema with Excel. - YouTube

My end goal is to produce a workbook that processes our raw sales data into the correct format, copy the tab with the final data to a new workbook and then import to Business Central with a Configuration package.

0 Replies