locked
Relationships for linked tables RRS feed

  • Question

  • Hello,

    I created tables in powerpivot by linking to data in the Excel worksheet. I was expecting to see relationships automatically created because the tables are related and have the appropriate ID fields in them. Does auto detection work for linked tables or does it only work for data that is imported into powerpivot?

    Thank you
    Tracy

    Thursday, November 11, 2010 10:29 PM

Answers

  • Tracy,

    I reproduced your issue. This is probably a product issue. At the current time being, you can manually create the relationship in your PowerPivot window to work around this issue. Meanwhile I recommend that you submit a feedback to SQL product team at https://connect.microsoft.com/sql so that they can further investigate and fix the issue in future.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    • Marked as answer by LadyTester Thursday, November 18, 2010 2:55 AM
    Wednesday, November 17, 2010 8:50 AM

All replies

  • Tracy,

    I reproduced your issue. This is probably a product issue. At the current time being, you can manually create the relationship in your PowerPivot window to work around this issue. Meanwhile I recommend that you submit a feedback to SQL product team at https://connect.microsoft.com/sql so that they can further investigate and fix the issue in future.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    • Marked as answer by LadyTester Thursday, November 18, 2010 2:55 AM
    Wednesday, November 17, 2010 8:50 AM
  • Hi Charles,

    Thank you. I will post this as a problem.

    Tracy

    Thursday, November 18, 2010 2:55 AM