Forum Discussion

MaxPowerBI's avatar
MaxPowerBI
Regular Visitor
6 years ago
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...
Dataflow
Need Help
swang123's avatar
swang123
Frequent Visitor
6 years ago

I'm having the exact same issue as well - were you able to solve this?

MaxPowerBI's avatar
MaxPowerBI
Regular Visitor
6 years ago

Hi, 

 

unfortunately not - though there is another post about problems with dataflow refresh-failures: https://community.powerbi.com/t5/Issues/Power-BI-Dataflow-refresh-fail/idi-p/795376

But it seems to not be the exact same issue since it could be solved by recreating the dataflow from scratch - which did not work with my problem...

 

Is there anyone else who has an idea on how to resolve that issue?

Could you help as with that case or do you need further information? v-qiuyu-msft 

 

Regards Max

 

fyi: The complete error-message of the refresh failure (in German): 

Ausführungszeit,Name des Dataflows,Aktualisierungsstatus für Dataflow,Entitätsname,Startzeit,Endzeit,Status der Entitätsaktualisierung,Fehler,
Invalid date,-views aus HS,Fehler,view_1_odbc,23/09/2019 09:49:05,23/09/2019 09:49:35,Fehler,Error: Der Schlüssel entsprach keiner Zeile in der Tabelle. Request ID: 046ed351-88b1-00d7-51fe-62aba1c4c33e Activity ID: e1a1b863-574a-4ad0-9ccb-874d2b757fbe
Invalid date,-views aus HS,Fehler,view_2_odbc,23/09/2019 09:49:35,23/09/2019 09:50:06,Fehler,Error: Der Schlüssel entsprach keiner Zeile in der Tabelle. Request ID: 046ed351-88b1-00d7-51fe-62aba1c4c33e Activity ID: c7db144e-a388-4dd5-8d11-00f671f6a88a
Invalid date,-views aus HS,Fehler,view_3_odbc,23/09/2019 09:50:06,23/09/2019 09:50:37,Fehler,Error: Der Schlüssel entsprach keiner Zeile in der Tabelle. Request ID: 046ed351-88b1-00d7-51fe-62aba1c4c33e Activity ID: 2847afe7-d16d-446f-89b7-bcfc1b1446b3
Invalid date,-views aus HS,Fehler,view_4_odbc,23/09/2019 09:50:37,23/09/2019 09:51:07,Fehler,Error: Der Schlüssel entsprach keiner Zeile in der Tabelle. Request ID: 046ed351-88b1-00d7-51fe-62aba1c4c33e Activity ID: c19ee5b7-792e-4d6d-9306-fd3abd04af06
Invalid date,-views aus HS,Fehler,view_5_odbc,23/09/2019 09:51:07,23/09/2019 09:51:38,Fehler,Error: Der Schlüssel entsprach keiner Zeile in der Tabelle. Request ID: 046ed351-88b1-00d7-51fe-62aba1c4c33e Activity ID: b9c8ec49-c559-407e-a2c3-5dc9953a0749
Invalid date,-views aus HS,Fehler,view_6_odbc,23/09/2019 09:51:38,23/09/2019 09:52:08,Fehler,Error: Der Schlüssel entsprach keiner Zeile in der Tabelle. Request ID: 046ed351-88b1-00d7-51fe-62aba1c4c33e Activity ID: 83c931cc-9f7b-4c07-91f3-a43d9b92d152
Invalid date,-views aus HS,Fehler,view_7_odbc,23/09/2019 09:52:08,23/09/2019 09:52:39,Fehler,Error: Der Schlüssel entsprach keiner Zeile in der Tabelle. Request ID: 046ed351-88b1-00d7-51fe-62aba1c4c33e Activity ID: 79141d8b-57ba-4016-8400-8ad2b02ecebf