Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
RemulusPrider
Frequent Visitor

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

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.

 

When I was developing the model, I changed the table and the model names, but I checked the names and found no mismatch between dev and QA.

 

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.

 

Another model in a different DB when I deploy works fine, but this model and another in this DB are having this issue. I also do not have the Entra ID P2 license, I don't know if this is related or not and I don't use any Excel file in the model. And I have access to the QA.

 

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

1 ACCEPTED SOLUTION
RemulusPrider
Frequent Visitor

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.

View solution in original post

5 REPLIES 5
RemulusPrider
Frequent Visitor

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.

Anonymous
Not applicable

Hi @RemulusPrider 

 

Glad to hear you solved the problem! Thank you for sharing. Could you please mark your solution as an ANSWER? This will help more users who are facing the same or similar difficulties. Thank you!

 

Best Regards,
Yulia Xu

lbendlin
Super User
Super User

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Thank you, I will try that!

Anonymous
Not applicable

Hi @RemulusPrider 

 

Thanks for the reply from lbendlin.

 

@RemulusPrider , Have you solved your problem? If solved, could you please share your solution? Please mark your reply as ANSWER after sharing. This will help more users who are facing the same or similar difficulties. Thank you!

 

Best Regards,
Yulia Xu

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.