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]
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).
Answer
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.