Powerview "Add this to the Data Model" checkbox is greyed out. RRS feed

  • Question

  • How can this checkbox "Add this to the Data Model" in the Import Data dialog box be made available and not greyed out?
    Monday, May 19, 2014 1:34 PM


  • Hi Rufino,

    Data Model is a new approach for integrating data from multiple tables, effectively building a relational data source inside the Excel workbook. Within Excel, Data Models are used transparently, providing data used in PivotTables, PivotCharts, and Power View reports. between the data sources.

    In your scenario, it seems that you import data from Analysis Services database. However, this option is not available for Analysis Services database. So in you want to made this option, you can import data from relational database.

    Reference:Introduction to the Data Model and Relationships in Excel 2013

    Charlie Liao

    If you have any feedback on our support, please click here

    Charlie Liao
    TechNet Community Support

    Tuesday, May 20, 2014 3:08 AM