Hello,
I started running into this issue of "key didn't match any rows" with the dashboard that I manage and i can't get close to a solution on that.
The funny thing is that everything refreshs without an issue from the desktop, but after the dashboard is published, it never refreshs and it throws those errors on different tables at random ( it usually changes after I go to Powerquery on desktop and refresh preview on all tables, then apply& close and refresh all data).
I also have some other dashboards consuming data from the same database, so I'd assume it's not on the server side.
Any one has any sugestion before I try to recreate the file from scratch(hoping this might be the last solution) ?
Data source error: Expression.Error: The key didn't match any rows in the table.. Microsoft.Data.Mashup.ErrorCode = 10061. Key = [Schema = "iam_billing", Item = "tb_allocation_target_account"]. Table = #table({"Name", "Data", "Schema", "Item", "Kind"}, {}). ;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: Allocation Target per account.
Cluster URI: WABI-US-NORTH-CENTRAL-D-PRIMARY-redirect.analysis.windows.net
Activity ID:
Request ID:
Time: 2025-04-08 18:57:12Z
EDIT:
I don't know why I can't reply this topic, but I guess I solved my own issue.
The dashboard probably had multiple credentials for the same data source. I reviewed all tables and set to the same configuration ( connecting to the database instead of the server + navigating to the database), cleared credentials and once the credential was refreshed, finally I could replicate the issue on the desktop.
Refreshed everything and it worked like a charm.😬
