Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Since I ran out of ideas about how to tackle the problem, I'd appreciate any help. Thanks!
Regards,
Max
Solved! Go to Solution.
See this post to have a workaround: https://community.powerbi.com/t5/Issues/Dataflows-Reload-not-working-from-one-day-to-another-with-er...
See this post to have a workaround: https://community.powerbi.com/t5/Issues/Dataflows-Reload-not-working-from-one-day-to-another-with-er...
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.