Forum Discussion
Solved
Dataflows - Reload not working from one day to another with error code "the key didnt match any rows
Hi, I've got a problem using dataflows. One of my dataflows worked absolutely fine until the day before yesterday. After that the dataflow could not refresh anymore. Various entities with the fo...
See this post to have a workaround: https://community.powerbi.com/t5/Issues/Dataflows-Reload-not-working-from-one-day-to-another-with-error/idc-p/801749#M48794
I am experiencing the same issue. My dataflows worked fine for the last 2 months and even though nothing has changed the flows are failing now. I can take the same code to a desktop power bi query and everything works fine - for whatever reason the bi dataflow is unable to sync and breaks at source.
I also updated our gateway and confirmed that the gateway connection is working/credentials are valid. We are connecting to a postgresql database hosted on an Azure VM using ODBC.
I'm not sure how to resolve the issue since it doesn't seem like it would have come from us.