Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. A data refresh on a table that uses an OData data source fails after you import an existing PowerPivot model

A data refresh on a table that uses an OData data source fails after you import an existing PowerPivot model

View products that this article applies to.

Symptoms

Consider the following scenario: 
  • You create a new BISM Tabular data model in Microsoft SQL Server 2012 Data Tools by importing an existing PowerPivot model.
  • The PowerPivot model was created by using the Microsoft SQL Server PowerPivot 2010 add-in. 
  • You try to run a data refresh on a table that uses an OData data source.
 In this scenario, the refresh fails. Additionally, you may receive the following error message:

The operation failed because the source does not contain the requested column. You can fix this problem by updating the column mappings.

More Details:

The '<ColumnName>' column does not exist in the rowset.

An error occurred while processing the partition '<GUID>' in table '<GUID>'.

The current operation was cancelled because another operation in the transaction failed.

↑ Back to the top

Cause

This issue occurs because of a change in the way OData table columns are mapped to the destination columns in the BISM Tabular data model.

↑ Back to the top

Resolution

To resolve this issue, edit the data mappings for the affected tables. Or, remove the tables and then re-import them.

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2779348
Revision : 1
Created on : 1/7/2017
Published on : 9/24/2013
Exists online : False
Views : 1014