[CoE Starter Kit - BUG] BYOD Report Dataflow Refresh Failure

[RamyaGunasekara]

Does this bug already exist in our backlog?

• I have checked and confirm this is a new bug.

Describe the issue

Hi Team,

We have a report named BYODL_CoEDashboard that contains data from COEtoolkit however the dataflow refresh is failing to process the table data. We have imported November 2024 DF file into our PowerBI Workspace and when we provide datalake URL and configure the connections and try to refresh for the first time, receiving below errors.

Tables Impacted: App Connections, Flow Connections, FlowUsage, Flows and Apps
Error: The current operation was canceled because one or more operations failed.. Request ID: 202b70d8-ed53-12a2-63c6-b504abb2e6f3.

Tables Impacted: Connections, AppUsage
Error: PipelineException: The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size.. RootActivityId = 9778c72b-760e-4bd7-b1a8-04c042d6d49d.Param1 = PipelineException: The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size. Request ID: 202b70d8-ed53-12a2-63c6-b504abb2e6f3.

When we try to configure the connection for the queries/tables of AppUsage and FlowUsage, it failed with the error 'Evaluation was cancelled', that's causing the cache limit issue making other tables refrain from getting processed during the scheduled trigger of dataflow. Can you please help us on this regard, as leadership closely monitors this report on weekly basis and issue to be addressed ASAP?

Screenshots attached for your reference.

PowerPlatformAdminAnalytics-DF-Jan2024_1_30_2025,_10_53_44_AM.csv

Expected Behavior

Dataflow should be refreshed after the trigger and data to be shown so that we will be able to map the refreshed dataflow to our BYODL_COE report.

What solution are you experiencing the issue with?

Governance

What solution version are you using?

4.45

What app or flow are you having the issue with?

Issue with dataflow PowerPlatformAdminAnalytics-DF-Jan2024

What method are you using to get inventory and telemetry?

Data Export

Steps To Reproduce

1.Try downloading the latest version of CEO starter toolkit
https://github.com/microsoft/coe-starter-kit
2.Upload Json file of dataflow (PowerPlatformAdminAnalytics-DF-Jan2024) into the Power BI workspace.
3.Try configuring the connections using dev account.
4.Trigger Refresh
5.Test the data using dummy PBI report if there's updated data for flows or apps table.
6.Update the BYODL_COEdashboard report pointing to the updated dataflow.
7.Schedule the refresh and see if there's expected data/data volume.

Anything else?

Need help in addressing the dataflow refresh issue on priority.

[RamyaGunasekara]

Hello Team, Do we have any updates on this?