Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MaxPowerBI
Regular 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
MaxPowerBI
Regular Visitor
4 REPLIES 4
MaxPowerBI
Regular Visitor
swang123
Frequent Visitor

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

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

Anonymous
Not applicable

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors