Forum Discussion
Dataflows not working from PowerBI service
Getting lots of errors around dataflows in the powerBI service. These are from working reports.
<ccon>Expression.Error: The key didn't match any rows in the table.. Microsoft.Data.Mashup.ErrorCode = 10061. Key = [workspaceId = "<>"]. Table = #table({"workspaceId", "workspaceName", "workspaceType"}, {}). </ccon>;<ccon>The key didn't match any rows in the table.</ccon>. The exception was raised by the IDbCommand interface. Table: DateTable
Issue resolved - it was a connection account refresh that was required.
5 Replies
Hi plover ,
The error you are getting indicates that the Power BI service is unable to match a key value , likely workspaceID to any existing row in a table specifically, a table that appears to be part of a dataflow.
To troubleshoot this, you can check-
1. If the referenced workspace may have been deleted or moved.Look for Source where it pulls from another workspace.Make sure the referenced workspaceID is still valid.2.If your dataflow uses linked entities from another workspace or dataflow, the link might be broken.
3.Access permissions to the source workspace or dataflow might have changed. You may no longer have access to the underlying data.
Additionally you can go through,
https://learn.microsoft.com/en-us/power-query/dataflows/troubleshooting-dataflows-issues-creating-dataflow
If still you are not able figure, you raise a support ticket.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!Issue resolved - it was a connection account refresh that was required.
