Forum Discussion
Solved
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 afterwar...
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!
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!!!