Forum Discussion
Report using dataflow - Data source error: Expression.Error: The key didn't match any rows
I'm using MS Fabric and have Admin permissions.
I created a workspace, a lakehouse, and uploaded a CSV file.
Then I created a dataflow that applies a simple transformation to the file, and afterward, I created a report in Power BI Desktop, using that dataflow as the data source.
Everything has been refreshing normally so far, but when I publish the PBIX file to MS Fabric, I can’t refresh the semantic model—I keep getting an error.
Data source error: Expression.Error: The key didn't match any rows in the table.. Microsoft.Data.Mashup.ErrorCode = 10061. Key = [workspaceId = 'xxxx']. Table = #table({'workspaceId', 'workspaceName', 'workspaceType'}, {}). ;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: sales csv. Cluster URI: redirect.analysis.windows.net Activity ID: zzzz Request ID: cccc Time: 2025-04-04 00:53:50Z
I’ve already tried publishing from Power BI Desktop as well as uploading it manually. The workspaceId is correct.
10 Replies
ricauduro
give it a tryIn Power BI Desktop, go to "File" > "Options and settings" > "Data source settings"
Clear permissions for the dataflow
Close and reopen Power BI Desktop
Refresh the dataflow connection and republish
Hi ricauduro
I replciated the same scenario, for me it's working.
- I think some data chnages happend in the dataflows or u added some data in pbix file which was not presented in dataflows.
- Make sure that, you have to publish the same workspace from where you connect with dataflows.
- check that, your dataflow also is refreshing correctly and that there are no errors in the dataflow itself.
- still u are facing the issue, try to recreatie the dataflow and reapplying the transformations. It can sometimes resolve your issues.
Let me know if it works.
Thank you!!!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!Yes, the daflow is published and I can refresh it without issues. The issue is only with the report semantic model. Thank you for your help
Unfortunally I could not manage to make it work with dataflows. I switched all the sources from my report to DWH an now I can refresh the report semantic model. Thank you for you help!!!
Hi ricauduro,
Thanks for actively participating in MS Fabric community
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Can accept this post as answer this will help other users find answers quickly.
Thanks,
Prashanth
