Relationship RRS feed

  • Question

  • I have created a Data model, which will link up all the tables.

    Structure is below,

    I have 4 tables.

    Table A ---à Table B   has Some amount filed(Amont1).



    Table C à Table D  has some Amount Field(Amount2).

    Table A has relationship with “Table B” and “Table c”, Table C has relationship with Table D.

    Now I would like to get the filed from “Table B” and “Table D”  and do some calculations.

    Now I have to achieve as  “Remainting Amt = Amount2 – Amount1” and this should be shown in the Pivot view.

    Error Occurring : When I am pulling the  Amount1 field from “Table B” to the “Table A”  I am getting the “Load to Data Model Failed.”


    1. Working on Excel 2013
    2. Connection to MS CRM 2013 with OData Feeds.

    Steps i followed are

    1) I have edit the table.
    2) I have added the column(Amount2) from the table c.
    3) I bought this column as we have Releationship name in MS CRM.
    4) when i click on "Close and load"

    I am getting the Error "Data load failed".

    Friday, August 21, 2015 11:17 AM


  • Thanks for reporting this issue. Can you hover over the query and tell me the error message that is showing in the flyout? If there is a Send a Frown button, please use that to send an e-mail to us so we can take a closer look.

    Wednesday, August 26, 2015 7:02 AM