SSAS Tabular Model Error: Object reference not set to an instance of an object. While trying to add tables to the tabular model

2
votes

I'm trying to create my first SSAS Tabular model. I'm following the steps mentioned in following tutorial:

https://msdn.microsoft.com/en-us/library/hh231690.aspx

While trying to load the tables to the model, I get the following error:

Blockquote

"!! Relationship: dbo.DimCustomer[GeographyKey]->dbo.DimGeography[GeographyKey]

  • Status: error

  • Reason:Object reference not set to an instance of an object.

!! Relationship: dbo.FactInternetSales[CustomerKey]->dbo.DimCustomer[CustomerKey]

  • Status: error

  • Reason:Object reference not set to an instance of an object.

!! Relationship: dbo.FactInternetSales[OrderDateKey]->dbo.DimDate[DateKey]

  • Status: error

  • Reason:Object reference not set to an instance of an object.

!! Relationship: dbo.FactInternetSales[DueDateKey]->dbo.DimDate[DateKey]

  • Status: error

  • Reason:Object reference not set to an instance of an object.

!! Relationship: dbo.FactInternetSales[ShipDateKey]->dbo.DimDate[DateKey]

  • Status: error

  • Reason:Object reference not set to an instance of an object.

!! Relationship: dbo.FactInternetSales[ProductKey]->dbo.DimProduct[ProductKey]

  • Status: error

  • Reason:Object reference not set to an instance of an object."

Blockquote

What shall I do to get rid of this error message?

I'm using SQL Server 2014 and Visual Studio 2015 (SSDT).

2
ssasssas-2012ssas-tabular

2 Answers

1
votes

this is because SSAS can not process data. I guess it's because of your impersonation setting in your connection. check your connection setting and test it again.

0
votes

This is probably because your model.bim is closed when you're trying to deploy. Change this to having the model open and try again.