Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to Solution.
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.
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.
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
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!
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
34 | |
26 | |
24 | |
23 |
User | Count |
---|---|
62 | |
52 | |
30 | |
25 | |
23 |