Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

jasperp

Power Bi Dataflows to Datalake Fail Sometimes

Submitted by on ‎05-10-2021 03:07 AM

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

@jasperp 

 

You may take a look at Understanding and optimizing dataflow refresh.

See more ideas labeled with:
1 Comment (1 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎05-10-2021 09:22 PM
Status changed to: New

@jasperp 

 

You may take a look at Understanding and optimizing dataflow refresh.

Idea Statuses