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!

Power BI Dataflow refresh fail

Hi,

 

Since this morning GMT time our dataflows don't get refreshed anymore.

No scheduled or manual refresh possible.

 

Internal error Request ID: 52ff8d68-06f2-b9af-c457-7c8d24ec5af1 Activity ID: 69c0d3af-4b0b-472a-8ece-11e8dcbdc30f

 

Any ideas?

Thanks

Frank

Status: New
Comments
theeri01
New Member

Hi

 

Same issue here.  My setup is on-premise data gateway on windows 2012 r2. This issue appears with latest windows update. I remove all update previously instaled and my on premisse gateway was able to communicate outside. 

(KB4019213)
(KB4498963)
(KB4503290)
(KB4507422)
(KB4507457)
(KB4511872)
(KB4512488)
(KB4512489)
(KB4012213)
(KB3092601)
(KB3048043)
(KB3132080)

 

the on-premisse data gateway is version 3000.8.452.

 

Hope someone found something, dont like to keep my server with security issue !

 

Eric

v-qiuyu-msft
Community Support

Hi all, 

 

Is there any error message occurs when you refresh dataflows? Please go to Refresh History and provide detail information for us. 

 

Best Regards,
Qiuyun Yu 

mpe
Regular Visitor

I have the same issues. The dataflow stops after a few seconds with refreshing.

v-qiuyu-msft
Community Support

@DebbieE It seems your issue is related to a dataset refresh rather than dataflow refresh. Please create a new thread with detail information provided. 

 

@mpe What's the error message pops out? Please share detail error information with us. 

 

Best Regards,
Qiuyun Yu 

mpe
Regular Visitor

These are the messages from two dataflows. The first one was updated on 18-9, but failed to update since then. The second one failed on 18/9 in the morning, but was able to update again in the evening of 18/9. It has worked since then.

Invalid date,Verdi Data Phalaenopsis,Mislukt,Verdi Basispool,20/09/2019 13:00:01,20/09/2019 13:00:35,Mislukt,Error: The key didn't match any rows in the table. Request ID: d9ba3168-59fd-470a-9cb7-7fe6f9a0eb76 Activity ID: 8a23b58a-bdeb-42bc-b52d-741adee67ce5

 

Invalid date,tabellen PhalBreed,Mislukt,TrialData,18/09/2019 11:10:24,18/09/2019 11:10:25,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: cc6d0ca5-a9cb-44d6-bd18-5e1d33cbbefc
Invalid date,tabellen PhalBreed,Mislukt,Jobs,18/09/2019 11:10:25,18/09/2019 11:10:26,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: 75e74ec1-7dc4-4673-afd8-3f7c5c57d79e
Invalid date,tabellen PhalBreed,Mislukt,Items,18/09/2019 11:10:26,18/09/2019 11:10:27,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: 326ced92-1a1e-4dd6-8248-923b7a95805e
Invalid date,tabellen PhalBreed,Mislukt,Properties Progeno,18/09/2019 11:10:27,18/09/2019 11:10:29,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: a51778be-f310-454a-bd20-a835cae1df11
Invalid date,tabellen PhalBreed,Mislukt,Hybrid table Crossings,18/09/2019 11:10:29,18/09/2019 11:10:30,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: 69232659-fb49-406e-a620-dea5eb9635fc
Invalid date,tabellen PhalBreed,Mislukt,Nakomelingen,18/09/2019 11:10:30,18/09/2019 11:10:31,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: 17c64840-c0c3-43dd-a9f0-53c252a33997
Invalid date,tabellen PhalBreed,Mislukt,Crossings,18/09/2019 11:10:31,18/09/2019 11:10:32,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: 1a2b6c31-edd8-446f-acf9-2bf749f181b7
Invalid date,tabellen PhalBreed,Mislukt,Seedling pop,18/09/2019 11:10:32,18/09/2019 11:10:33,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: 92ad95e7-c92f-4efa-b155-6aafb5ab7396
Invalid date,tabellen PhalBreed,Mislukt,Jobs in lab,18/09/2019 11:10:33,18/09/2019 11:10:34,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: 9056f5e6-2abf-4484-bf5d-3a3f8b16f643
Invalid date,tabellen PhalBreed,Mislukt,Properties AW Item,18/09/2019 11:10:34,18/09/2019 11:10:35,Mislukt,Error: Internal error Request ID: 89f25160-f236-98f1-2f4e-4ce3c78056f8 Activity ID: ac2e78cb-78f7-44d1-83c5-6abb500e4513
Goofr
Advocate IV

Hi,

 

I had the same error.

Ended up recreating all dataflows (copy paste form the broken one) and updating all my reports.
One day of work..

 

BI-Geniuz
Advocate I

any updates on this matter? I'm experiencing the same issue since 19-09-2019 as well.

mpe
Regular Visitor

I did some rework on one of the dataflows. It concerned an ODBC data source. After changing the code (shortening) it workes again.

 

Has there been an update in the dataflows on working with ODBC data sources?

BI-Geniuz
Advocate I

Hi,

 

@mpe thanks for your response. I'm working with ODBC as well. Can you show some of the modding you've done in the syntax ?

mpe
Regular Visitor

@BI-Geniuz There were three lines describing which table I needed from the ODBC source.

 

let
Source = Odbc.DataSource("dsn=xxx"),
v_ant_anth_prd_Database = Source{[Name = "xx", Kind = "Database"]}[Data],
informix_Schema = v_ant_anth_prd_Database{[Name = "x", Kind = "Schema"]}[Data],
basispool_Table = informix_Schema{[Name = "xxxx", Kind = "Table"]}[Data]
 
I have changed it to one line
 
let
Source = Odbc.DataSource("dsn=xxx"),
Navigate = Source{[Item = "xxxx", Schema = "x", Catalog = "xx"]}[Data],