cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MaxPowerBI Frequent Visitor
Frequent Visitor

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 following code don't refresh within a dataflow-entity but refresh smoothly within a report / dataset in the power bi service.

 

The error code in the dataflow is "the key didnt match any rows in the table" 

 

The code is the following: 

let
Quelle = Odbc.DataSource("dsn=XXODBCXX"),
TEST_Schema = Quelle{[Name = "TEST", Kind = "Schema"]}[Data],
Test_Bi_View = TEST_Schema{[Name = "Test_Bi", Kind = "View"]}[Data]
in
Test_Bi_View

 

Already performed tests: 

  • Updated gateway to latest version
  • Inserted the exact same code into a report, published the report and performed a refresh in power BI service -> successful
  • Tried to alter the dataflow entities, but it is not possible since the entities show errors even at the first step ("source") with the error message "Es wurde ein unerwarteter Fehler festgestellt" (Means as much as: "An unexpected error occurred")

Since I ran out of ideas about how to tackle the problem, I'd appreciate any help. Thanks!

 

Regards,
Max

1 ACCEPTED SOLUTION

Accepted Solutions
MaxPowerBI Frequent Visitor
Frequent Visitor

Re: Dataflows - Reload not working from one day to another with error code "the key didnt match

4 REPLIES 4
derick Occasional Visitor
Occasional Visitor

Re: Dataflows - Reload not working from one day to another with error code "the key didnt match

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. 

swang123 Frequent Visitor
Frequent Visitor

Re: Dataflows - Reload not working from one day to another with error code "the key didnt match

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

MaxPowerBI Frequent Visitor
Frequent Visitor

Re: Dataflows - Reload not working from one day to another with error code "the key didnt match

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

MaxPowerBI Frequent Visitor
Frequent Visitor

Re: Dataflows - Reload not working from one day to another with error code "the key didnt match

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 322 members 3,328 guests
Please welcome our newest community members: