cancel
Showing results for 
Search instead for 
Did you mean: 

Power Bi Dataflows to Datalake Fail Sometimes

Hello,

Currently, there is a Dataflow that has been setup with as source OData that comes from Project Server. The data of the dataflow is every night copied to an Azure Data Lake Gen2 storage. The problem is that this sometimes gives an error, and sometimes is doesn't. When I download the error, I get the following:


Requested on,Dataflow name,Dataflow refresh status,Table name,Partition name,Refresh status,Start time,End time,Duration,Rows processed,Bytes processed (KB),Max commit (KB),Processor Time,Wait time,Compute engine,Error,
2021-05-10 11:35:08,ProjectServer_IT,Failed,Projects,NA,Completed,2021-05-10 11:35:08,2021-05-10 11:35:39,00:00:31.3100,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:35:39,ProjectServer_IT,Failed,Resources,NA,Completed,2021-05-10 11:35:39,2021-05-10 11:36:10,00:00:31.1000,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:36:10,ProjectServer_IT,Failed,AssignmentBaselines,NA,Completed,2021-05-10 11:36:10,2021-05-10 11:36:41,00:00:30.9900,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:36:41,ProjectServer_IT,Failed,Assignments,NA,Completed,2021-05-10 11:36:41,2021-05-10 11:39:44,00:03:03.1770,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:39:44,ProjectServer_IT,Failed,Deliverables,NA,Completed,2021-05-10 11:39:44,2021-05-10 11:43:16,00:03:31.8830,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:43:16,ProjectServer_IT,Failed,FiscalPeriods,NA,Completed,2021-05-10 11:43:16,2021-05-10 11:46:19,00:03:02.9860,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:46:19,ProjectServer_IT,Failed,Issues,NA,Completed,2021-05-10 11:46:19,2021-05-10 11:48:51,00:02:31.5170,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:48:51,ProjectServer_IT,Failed,ProjectBaselines,NA,Completed,2021-05-10 11:48:51,2021-05-10 11:50:52,00:02:01.0730,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:50:52,ProjectServer_IT,Failed,Risks,NA,Completed,2021-05-10 11:50:52,2021-05-10 11:51:23,00:00:31.0000,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:51:23,ProjectServer_IT,Failed,TaskBaselines,NA,Completed,2021-05-10 11:51:23,2021-05-10 11:53:25,00:02:02.0830,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:53:25,ProjectServer_IT,Failed,Tasks,NA,Completed,2021-05-10 11:53:25,2021-05-10 11:53:56,00:00:31.2160,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:53:56,ProjectServer_IT,Failed,TimeSet,NA,Completed,2021-05-10 11:53:56,2021-05-10 11:54:27,00:00:31.0600,NA,NA,NA,NA,NA,NA,NA
2021-05-10 11:54:27,ProjectServer_IT,Failed,TimesheetLineActualDataSet,NA,Failed,2021-05-10 11:54:27,2021-05-10 11:56:08,00:01:40.5240,NA,NA,NA,NA,NA,NA,Error: Internal error Request ID: 837705f2-0be8-d814-45aa-04f434194466 Activity ID: 00000000-0000-0000-0000-000000000000

 

The error itself gives no further information. There is only a Request Id (837705f2-0be8-d814-45aa-04f434194466), but this doesn't help me as well. When I look in the refresh history, most of the times it works well, but it fails sometimes.

jasperp_0-1620641207335.png

 

Anybody who can help or who knows in what direction I should look to solve this problem?

Thanks!



Status: New
Comments
v-chuncz-msft
Community Support
Status changed to: New