Powerpovit realtionship can not reflect when drag the dimension table

Question

Hello friends,

I create two tables "factOrderLine"(dealerID FK) and "dimdealer"(DealerNumber PK). And the relationship is pretty easy as taking the dimDealer as the lookup table. Both varchar(50)

After creating the pivot, pulling an dealerPhoneNumber and dealerName in the dimension of dimDealer. It errors out as below.

Any idea?

============================
Error Message:
============================

Exception from HRESULT: 0x800A03EC
----------------------------

----------------------------
The command was canceled. Please press F1 to get the help topic "Excel Window: PowerPivot Field List" for more details.

============================
Call Stack:
============================

Server stack trace:

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.Office.Interop.Excel.CubeField.set_Orientation(XlPivotFieldOrientation RHS)
   at Microsoft.AnalysisServices.XLHost.Addin.ExcelInterOpUtil.AddToFields(String cubeFieldName, XlPivotFieldOrientation pivotOrientation, Int32 positionIndex)
----------------------------
   at Microsoft.AnalysisServices.XLHost.Addin.ExcelInterOpUtil.AddToFields(String cubeFieldName, XlPivotFieldOrientation pivotOrientation, Int32 positionIndex)
   at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.SetFieldOrientation(PivotArea location, IGeminiColumn column, Int32 positionIndex)
----------------------------
   at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.SetFieldOrientation(PivotArea location, IGeminiColumn column, Int32 positionIndex)
   at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.AddToFieldListInternal(PivotArea location, IGeminiColumn column, Int32 positionIndex)
   at Microsoft.AnalysisServices.XLHost.Addin.GeminiPivot.MoveField(IGeminiColumn column, PivotArea source, PivotArea target, Int32 positionIndex)
   at Microsoft.AnalysisServices.XLHost.Addin.FieldListControl.MoveFieldInternal(IGeminiColumn field, PivotArea sourceArea, PivotArea targetArea, Int32 targetIndex)

============================

---

Derek

Answer 1

Hi Derek,

This issue has been submitted at connect site, please refer to this link http://connect.microsoft.com/SQLServer/feedback/details/511840/powerpivot-ctp3-initialization-of-the-data-source-failed 

---

Challen Fu

TechNet Community Support