CODEWITHSUNDEEP
ssasssas-2012ssas-tabular
MSBI_Student
MSBI_Student

Reputation: 21

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

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]

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

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

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

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

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

Blockquote

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

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

Upvotes: 2

Views: 13684

Answers (3)

Pruthviraj Vachhani
Pruthviraj Vachhani

Reputation: 97

Same error but different solution - My case, I had two calculated fields with same name. Don't know how Tabular allowed it but removing old one resolved the issue. Hope this helps someone.

Upvotes: 0

Raj More
Raj More

Reputation: 48024

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.

Upvotes: 0

RmN
RmN

Reputation: 36

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.

Upvotes: 1

Related Questions