locked
Importing PowerPivot to SSAS Tabular Model RRS feed

  • Question

  • I'm getting this error when trying to create a Tabular Project importing a PowerPivot.

    An error occurred while opening the model on the workspace database. Reason: Could not import the pasted tables from PowerPivot. Reason: VertiPaq property 'ID' cannot have name binding.

    I need to know what the issue is. Please help.

    Tom Totten

    Thursday, September 24, 2015 3:35 PM

Answers

  • Hi ttotten,

    There can be many reasons causing this issue. It might be permission issue so that you can't bind name with that column. Please check if you can access the underlying relational database. Or you can turn off the DirectQuery mode.

    Also it looks like the 'ID' can be the primary key column. If there's any duplicated or empty value, it will also throw this error. So please check the records in that table.

    Regards,


    Simon Hou
    TechNet Community Support


    Friday, September 25, 2015 12:29 PM