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

Dataflow
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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