Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Datasets can't refresh after May Power BI Service update

Since 5/26/2023 our Datasets stopped refreshing on PBI Service with error:
Expression.Error: The key didn't match any rows in the table.. Key = <ccon>[workspaceId = "5c4c8bf7-d622-498f-821a-01e2ad6898dc"]. Table = #table({"workspaceId", "workspaceType", "Data", "workspaceName", "Tags", "ItemKind", "ItemName", "IsLeaf"}, {}). </ccon>;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: Dim Insuredname.

 

We have set up:
On premises gateway -> Dataflows -> datasets -> reports

Each time refresh error is pointing on a different table.
Nothing did change on our side since Friday and failure is on every environment we have.

Interestingly other datasets that do not use dataflows are fine and we can refresh datasets poinitng to dataflows in Power BI Desktop. We also try to redeploy datasets but they still fail refresh in Power BI Service. There is no errors on dataflows and amount of data loaded seems the same.


Any ideas why this is happening?

2 Replies

  • edhans's avatar
    edhans
    Community Champion

    You should contact support. I work with DF's daily and have not seen any similar issues this week.

  • dflynn44's avatar
    dflynn44
    Frequent Visitor

    Thank you for sharing.  We started experiencing the exact same behavior yesterday.  We are filing a ticket with MS today.