Forum Discussion

ricauduro's avatar
ricauduro
Regular Visitor
1 year ago
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...
capacities
  • ricauduro's avatar
    ricauduro
    1 year ago

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

nilendraFabric's avatar
nilendraFabric
Super User
1 year ago

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's avatar
ricauduro
Regular Visitor
1 year ago

Thank you but it didn´t worked