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

[MaxPowerBI]

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")
• Already posted this to the community 09/20/19 - but without success: See here https://community.powerbi.com/t5/Service/Dataflows-Reload-not-working-from-one-day-to-another-with-e...

@swang123 & @Anonymous - for your information.

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

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]

UPDATE: The code shown above does still result in the same error. However the following code within the dataflow-entity works now: 

let
  Quelle = Odbc.DataSource("dsn=XXODBCXX"),
  Navigation = Quelle{[Item = "XXVIEW_NAMEXX", Schema = "XXSCHEMA_NAMEXX", Catalog = null]}[Data]
in
  Navigation

for your information: @Anonymous  & @swang123 

However, is there any way to fix the problem above? the behaviour of the dataflow does still not match the behaviour of the dataset in Power BI Service.

Regards 
Max

[v-qiuyu-msft]

Hi @MaxPowerBI, 

I would suggest you create a support ticket to get dedicated help. 

Best Regards,
Qiuyun Yu