Failed to create connection for connection id '/providers/Microsoft.PowerApps/apis/shared_powerplatformadminv2/... Connection creation/edit of 'shared_powerplatformadminv2' has been blocked by Data Loss Prevention (DLP) policy

[RegassaKedir]

Does this bug already exist in our backlog?

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

Describe the issue

During upgrade we are getting an an error "Failed to create connection for connection id '/providers/Microsoft.PowerApps/apis/shared_powerplatformadminv2/connections/shared-powerplatform-ddc17df0-4d92-4980-884f-c49c0125ec80'. Connection creation/edit of 'shared_powerplatformadminv2' has been blocked by Data Loss Prevention (DLP) policy 'Global Org-wide Policy'."

Expected Behavior

Expected to run the update without an issue. We couldn’t update the solution due to the error.

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.32

What app or flow are you having the issue with?

Upgrading COE Kit

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

No response

Anything else?

No response

[Jenefer-Monroe]

Hello this is a new connector used in the kit, you will need to upgrade the DLP policy for the envt. Please see Validate data loss prevention (DLP) policies

[RegassaKedir]

Jennifer, thank you. I was able to adjust the DLP policy and resolve the issue. However, after doing that, I encountered another problem. The solution failed to update and couldn’t remove and replace the old solution, resulting in the following error. Can you please help?

"Information Error code 8004F01D Exception message Solution dependencies exist, cannot uninstall. DependencyCount : 1 RequiredComponentObject details:... See more

Total operation time 4 sec Patch Yes Managed Yes Overwrite customizations No Activity id"

[Jenefer-Monroe]

there have been some issues lately with the upgrade code. Can you get me the rest of the error message?

[RegassaKedir]

Error code 8004F01D Exception message Solution dependencies exist, cannot uninstall. DependencyCount : 1 RequiredComponentObject details: Type: SavedQuery, ObjectName: Abandoned PowerApps, Id: f9d327af-b6b4-e911-a85b-000d3a372932, ParentObjectName: PowerApps App, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: epacoe_PowerPlatformUserView, Id: eeb4bcb7-ea12-ef11-9f8a-001dd8306c96, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published See less

Total operation time 4 sec Patch Yes Managed Yes Overwrite customizations No Activity id 5bd43a56-cea2-4376-915e-f400af5a7976

[RegassaKedir]

Hi Jenefer - the above error is from the history tab, and I also included the below error that appears as a banner when the failure happens

"Solution "Center of Excellence - Core Components" failed to import: Solution Upgrade action failed after import as holding. InnerException is: Solution dependencies exist, cannot uninstall. DependencyCount : 1 RequiredComponentObject details: Type: SavedQuery, ObjectName: Abandoned PowerApps, Id: f9d327af-b6b4-e911-a85b-000d3a372932, ParentObjectName: PowerApps App, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: epacoe_PowerPlatformUserView, Id: eeb4bcb7-ea12-ef11-9f8a-001dd8306c96, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published ."

[Jenefer-Monroe]

Hello. A few other users have hit this and we were able to find a workaround. See https://github.com/microsoft/coe-starter-kit/issues/8682 The change: We removed a view called Abandoned PowerApps from the kit as it was found to be a confusing duplicate. We did remove it from the MDA's at that time as well of course or it would not have let me delete it. The issue: For some reason the product's upgrade code is choking on this for some users. I think its because its reviewing all the views and seeing that one has a dependency before checking to see if that dependency had been removed from the MDA. The workaround This worked for the other person, you can try to remove our dependency on it manually and see if that fixes

1. Remove the _upgrade core solution if it exists
2. Go to Apps > find the Power Platform Admin View app > Edit
3. Remove the problematic view and publish
4. Try your upgrade again.

[RegassaKedir]

I followed the procedure removed the "Abandoned Power App" view. Tried to update again and another error attached.

Here is the failure from the history tab "Error code 8004F01D Exception message Solution dependencies exist, cannot uninstall. DependencyCount : 1 RequiredComponentObject details: Type: SavedQuery, ObjectName: Abandoned PowerApps, Id: f9d327af-b6b4-e911-a85b-000d3a372932, ParentObjectName: PowerApps App, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: epacoe_PowerPlatformUserView, Id: eeb4bcb7-ea12-ef11-9f8a-001dd8306c96, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published See less

Total operation time 4 sec Patch Yes Managed Yes Overwrite customizations No Activity id 56d88c0f-7516-4726-ae75-7d40945ec536"

[DarkestOfNights]

@RegassaKedir - I know of this problem personally. The problem is the copy of the Power Platform Admin view that was made for non-admin users a while back - "Power Platform User View". It hadn't interfered with updates previously, but must with recent updates to the CoE. If you remove that app, you should be able to perform the upgrade. - TH

[Jenefer-Monroe]

As @DarkestOfNights indicates it appears you have a custom app in your tenant that still has the dependency. In the error message it shows its name, so you will need to find it and either remove the dependency or delete the app.

Thanks for your help!

[RegassaKedir]

Jenefer - We deleted the app ‘Power Platform Admin View’. We tried to delete the CoE core component upgrades to reinstall it again and encountered another issue.

"Error code 8004F01D Exception message Solution dependencies exist, cannot uninstall. DependencyCount : 6 RequiredComponentObject details: Type: SavedQuery, ObjectName: Shared With Guests - Owner, Id: b722f4c3-a52c-ef11-840a-000d3a352a2a, ParentObjectName: PowerApps App, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: admin_PowerPlatformAdminView, Id: f1be0217-5fa5-ec11-b400-001dd804f8b1, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published RequiredComponentObject details: Type: SavedQuery, ObjectName: Shared With Guests - Owner, Id: cfa20cb6-a52c-ef11-840a-00224803bae7, ParentObjectName: Flow, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: admin_PowerPlatformAdminView, Id: f1be0217-5fa5-ec11-b400-001dd804f8b1, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published RequiredComponentObject details: Type: SavedQuery, ObjectName: Shared With Guest - Editor, Id: 876fb7b2-ef2c-ef11-840b-0022480c0873, ParentObjectName: PowerApps App, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: admin_PowerPlatformAdminView, Id: f1be0217-5fa5-ec11-b400-001dd804f8b1, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published RequiredComponentObject details: Type: SavedQuery, ObjectName: Shared With View, Id: dd84538d-a02a-ef11-840a-6045bd07060c, ParentObjectName: Flow, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: admin_PowerPlatformAdminView, Id: f1be0217-5fa5-ec11-b400-001dd804f8b1, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published RequiredComponentObject details: Type: SavedQuery, ObjectName: Shared With Guests, Id: f5812025-a12a-ef11-840a-6045bd07060c, ParentObjectName: Flow, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: admin_PowerPlatformAdminView, Id: f1be0217-5fa5-ec11-b400-001dd804f8b1, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published RequiredComponentObject details: Type: SavedQuery, ObjectName: Shared With Guest - Editor, Id: 9c3e32be-ef2c-ef11-840a-6045bd07060c, ParentObjectName: Flow, ParentId: 00000000-0000-0000-0000-000000000000, DependentComponentObject details: Type: AppModule, ObjectName: admin_PowerPlatformAdminView, Id: f1be0217-5fa5-ec11-b400-001dd804f8b1, ParentObjectName: , ParentId: 00000000-0000-0000-0000-000000000000 DependencyType: Published See less

Total operation time 7 sec Patch Yes Managed Yes Overwrite customizations No Activity id 7ce4a387-e35d-494d-930e-7ea8007b1632"

[Jenefer-Monroe]

You may benefit from trying a classic overwrite

Classic overwrite upgrade

How to do an overwrite upgrade in the classic UX:

Switch to classic

Import

Select Core > Next

Next

Overwrite customizations > Import

---

[RegassaKedir]

Jenefer - Thank you for your help. I was able to remove the dependencies and delete the core component upgrade. I am now able to install and update the core component solution successfully.

One last question: I am trying to update the [Center of Excellence - Governance Components], but I don’t see a solution with that name in the CoE Starter Kit?

[Jenefer-Monroe]

Wonderful news!

The Gov components are held today in the "CenterofExcellenceAuditComponents_3_25_managed.zip" file

Please see the Before setting up the governance components

[RegassaKedir]

Jenefer,

We were able to successfully upgrade “CenterofExcellenceAuditComponents_3_25_managed.zip.”

However, we are now experiencing issues with the Power BI report of the Power Platform COE dashboard. The refresh has been failing for the past couple of days. Below are the error details:

"the Data source error: Expression.Error: The column 'admin_totalshared' of the table wasn't found.. admin_totalshared. . The exception was raised by the IDbCommand interface. Table: Power Apps. Cluster URI: WABI-US-GOV-VIRGINIA-redirect.analysis.usgovcloudapi.net Activity ID: 4d3ca2b9-8bbb-4264-9fc3-1bebc5b523c6 Request ID: 0e2892b1-2c77-b167-1079-28c0cf782f6a Time: 2024-10-16 12:48:34Z"

[Jenefer-Monroe]

What PBIT file did you use?

[Jenefer-Monroe]

closing out as no further action for starter kit team

[RegassaKedir]

Hello Jenefer - We are still having issue with refreshing the COE Power BI report. It has been working for the last two years.