The key does not match any row in the table - SSAS/PBI

[RemulusPrider]

I created a SSAS model in Visual Studio and deployed it to QA. But then I am facing an issue saying that:

The key does not match any row in the table.. Key=(Schema="view", Item="TablesName". Table=#table({"Name", "Data", "Schema", "Item", "Kind"}. {}) The key does not match any row in the table..

The only way I found to fix this is when I go to SSAS and update my credentials manually, but doing this I stop the automatic update.

I also took the first version of the model and deployed it, I have already rebuilt the model from scratch, I have already deployed one table at a time or used different tables, added and removed the relationship, but no sucess.

I would appreciate if anyone could give me some insigths what I could try different or direct me in the right way.

[Anonymous]

Hi @RemulusPrider ,

Please double-check that the key columns in your model match the key columns in the source data. Any mismatch can cause this error. ensure that the schema, item, and table names are correctly specified.
All relationships between tables should be correctly defined and there are no missing or incorrect relationships. 

Best regards.
Community Support Team_Caitlyn

[RemulusPrider]

The solution was to correct the credentials registered in the database. When the model was deployed with credentials that differed from those in the DB, the model was unable to access the tables in the database.