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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.