Report using dataflow - Data source error: Expression.Error: The key didn't match any rows

[ricauduro]

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.

[v-prasare]

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

[ricauduro · Accepted solution]

Hi @v-prasare , thank you for your contact. 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!!!

[v-prasare]

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

[v-prasare]

Can accept this post as answer this will help other users find answers quickly.

Thanks,

Prashanth

[nilendraFabric]

@ricauduro 

give it a try 

• In 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

[ricauduro]

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!!!

[ricauduro]

Thank you but it didn´t worked

[suparnababu8]

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!

[ricauduro]

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!!!

[ricauduro]

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