[CoE Starter Kit - BUG] ISSUE TITLE

[SomarajuA]

Does this bug already exist in our backlog?

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

Describe the issue

Environment not visible.pdf

We are unable to find environments in Power BI COE reports even though I can find the environments in Power Platform admin center. We can see that the dataset is also refreshed recently, but we are still not able to see the environments in Power BI COE reports.

When we raised a request with MS Support, they have asked to create a ticket with you. Please see the attached PDF for the conversation which we had with MS Support. Also please see the screenshots which shows the enviroment in admin center, but not in COE reports.

Expected Behavior

Power BI COE reports should show all the available environments

What solution are you experiencing the issue with?

Governance

What solution version are you using?

Not sure

What app or flow are you having the issue with?

Power BI

What method are you using to get inventory and telemetry?

None

Steps To Reproduce

No response

Anything else?

No response

AB#196

[Jenefer-Monroe]

Hello lets first see what version of the kit you are on Can you please share a screenshot like this so we can see what solutions you have installed in this environment? Be sure to show all records (all rows) and expand the indicated columns so that we can see full names

[SomarajuA]

Hi Jenefer,

We have a lot of rows which will not suffice in one screenshot. I am attaching screenshot with the top rows. Please let me know if it is fine or if I need to apply any filters.

@.***

Best Regards, Somaraju Ankolu

@.***

Somaraju Ankolu Global Technology Automation Team Mobile: +91 9701777172

ManpowerGroup @.*** www.manpowergroup.comhttp://www.manpowergroup.com/ For any issue with Automation please raise a ticket in ServiceNow herehttps://mpgemea.service-now.com/gtesc

From: Jenefer Monroe @.> Sent: 12 October 2023 17:40 To: microsoft/coe-starter-kit @.> Cc: Ankolu, Somaraju @.>; Author @.> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] ISSUE TITLE (Issue #6851)

BE ALERT: The sender of this email is outside of ManpowerGroup. Please check that you recognize the sender before opening links or attachments. If in doubt, use the Report Spam or Report Phishing buttons at the top of your Outlook toolbar to report a concern.

Hello lets first see what version of the kit you are on Can you please share a screenshot like this so we can see what solutions you have installed in this environment? Be sure to show all records (all rows) and expand the indicated columns so that we can see full names [image]https://user-images.githubusercontent.com/89584709/221184839-4ed24d69-24ac-426e-a909-889e3b230166.png

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/coe-starter-kit/issues/6851#issuecomment-1759481247, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BDGZ663AQD57GCNLBVLHDSDX67MX3ANCNFSM6AAAAAA55PRS74. You are receiving this because you authored the thread.Message ID: @.**@.>>

[Jenefer-Monroe]

Hello multiple screenshots would be fine. However please not that you must log in to GitHub to share images, they do not come through if you respond in email. Can you please log in to GitHub and share?

[SomarajuA]

Hi Jenefer/team,

Please let us know if there is any update here.

Best Regards, Somaraju Ankolu

@.***

Somaraju Ankolu Global Technology Automation Team Mobile: +91 9701777172

ManpowerGroup @.*** www.manpowergroup.comhttp://www.manpowergroup.com/ For any issue with Automation please raise a ticket in ServiceNow herehttps://mpgemea.service-now.com/gtesc

From: Ankolu, Somaraju Sent: 12 October 2023 18:22 To: microsoft/coe-starter-kit @.>; microsoft/coe-starter-kit @.> Cc: Author @.>; Aluri, Haribabu @.>; Chaudhuri, Supta @.***> Subject: RE: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] ISSUE TITLE (Issue #6851)

Hi Jenefer,

We have a lot of rows which will not suffice in one screenshot. I am attaching screenshot with the top rows. Please let me know if it is fine or if I need to apply any filters.

@.***

Best Regards, Somaraju Ankolu

@.***

Somaraju Ankolu Global Technology Automation Team Mobile: +91 9701777172

ManpowerGroup @.**@.> www.manpowergroup.comhttp://www.manpowergroup.com/ For any issue with Automation please raise a ticket in ServiceNow herehttps://mpgemea.service-now.com/gtesc

From: Jenefer Monroe @.**@.>> Sent: 12 October 2023 17:40 To: microsoft/coe-starter-kit @.**@.>> Cc: Ankolu, Somaraju @.**@.>>; Author @.**@.>> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] ISSUE TITLE (Issue #6851)

BE ALERT: The sender of this email is outside of ManpowerGroup. Please check that you recognize the sender before opening links or attachments. If in doubt, use the Report Spam or Report Phishing buttons at the top of your Outlook toolbar to report a concern.

Hello lets first see what version of the kit you are on Can you please share a screenshot like this so we can see what solutions you have installed in this environment? Be sure to show all records (all rows) and expand the indicated columns so that we can see full names [image]https://user-images.githubusercontent.com/89584709/221184839-4ed24d69-24ac-426e-a909-889e3b230166.png

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/coe-starter-kit/issues/6851#issuecomment-1759481247, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BDGZ663AQD57GCNLBVLHDSDX67MX3ANCNFSM6AAAAAA55PRS74. You are receiving this because you authored the thread.Message ID: @.**@.>>

[SomarajuA]

Hi Jenefer and Team,

Please refer following screenshots that have the CoE tool kit solutions details, let us know if you need any further details.

Unmanaged solutions @.***

Managed solutions: @.***

Regards, Hari

From: Ankolu, Somaraju @.> Sent: Friday, October 13, 2023 12:35 PM To: microsoft/coe-starter-kit @.>; microsoft/coe-starter-kit @.> Cc: Author @.>; Aluri, Haribabu @.>; Chaudhuri, Supta @.> Subject: RE: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] ISSUE TITLE (Issue #6851)

Hi Jenefer/team,

Please let us know if there is any update here.

Best Regards, Somaraju Ankolu

@.***

Somaraju Ankolu Global Technology Automation Team Mobile: +91 9701777172

ManpowerGroup @.**@.> www.manpowergroup.comhttp://www.manpowergroup.com/ For any issue with Automation please raise a ticket in ServiceNow herehttps://mpgemea.service-now.com/gtesc

From: Ankolu, Somaraju Sent: 12 October 2023 18:22 To: microsoft/coe-starter-kit @.**@.>>; microsoft/coe-starter-kit @.**@.>> Cc: Author @.**@.>>; Aluri, Haribabu @.**@.>>; Chaudhuri, Supta @.**@.>> Subject: RE: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] ISSUE TITLE (Issue #6851)

Hi Jenefer,

We have a lot of rows which will not suffice in one screenshot. I am attaching screenshot with the top rows. Please let me know if it is fine or if I need to apply any filters.

@.***

Best Regards, Somaraju Ankolu

@.***

Somaraju Ankolu Global Technology Automation Team Mobile: +91 9701777172

ManpowerGroup @.**@.> www.manpowergroup.comhttp://www.manpowergroup.com/ For any issue with Automation please raise a ticket in ServiceNow herehttps://mpgemea.service-now.com/gtesc

From: Jenefer Monroe @.**@.>> Sent: 12 October 2023 17:40 To: microsoft/coe-starter-kit @.**@.>> Cc: Ankolu, Somaraju @.**@.>>; Author @.**@.>> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] ISSUE TITLE (Issue #6851)

BE ALERT: The sender of this email is outside of ManpowerGroup. Please check that you recognize the sender before opening links or attachments. If in doubt, use the Report Spam or Report Phishing buttons at the top of your Outlook toolbar to report a concern.

Hello lets first see what version of the kit you are on Can you please share a screenshot like this so we can see what solutions you have installed in this environment? Be sure to show all records (all rows) and expand the indicated columns so that we can see full names [image]https://user-images.githubusercontent.com/89584709/221184839-4ed24d69-24ac-426e-a909-889e3b230166.png

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/coe-starter-kit/issues/6851#issuecomment-1759481247, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BDGZ663AQD57GCNLBVLHDSDX67MX3ANCNFSM6AAAAAA55PRS74. You are receiving this because you authored the thread.Message ID: @.**@.>>

[Jenefer-Monroe]

Hello, I'm afraid I still cannot see your screenshots. You need to login to GitHub to share them. Sharing via attaching to email responses does not work.

[SomarajuA]

[SomarajuA]

Hi Jenefer,

I have uploaded the screenshots in github.

Best Regards, Somaraju Ankolu

@.***

Somaraju Ankolu Global Technology Automation Team Mobile: +91 9701777172

ManpowerGroup @.*** www.manpowergroup.comhttp://www.manpowergroup.com/ For any issue with Automation please raise a ticket in ServiceNow herehttps://mpgemea.service-now.com/gtesc

From: Jenefer Monroe @.> Sent: 13 October 2023 17:36 To: microsoft/coe-starter-kit @.> Cc: Ankolu, Somaraju @.>; Author @.> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] ISSUE TITLE (Issue #6851)

BE ALERT: The sender of this email is outside of ManpowerGroup. Please check that you recognize the sender before opening links or attachments. If in doubt, use the Report Spam or Report Phishing buttons at the top of your Outlook toolbar to report a concern.

Hello, I'm afraid I still cannot see your screenshots. You need to login to GitHub to share them. Sharing via attaching to email responses does not work.

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/coe-starter-kit/issues/6851#issuecomment-1761406028, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BDGZ666SWZYZML6PK62A5M3X7EVBDANCNFSM6AAAAAA55PRS74. You are receiving this because you authored the thread.Message ID: @.**@.>>

[Jenefer-Monroe]

Wonderful! You are on an old version of the kit. (Feb 2023) so lets gather a few more details to know what direction to go:

1. Did you install the kit yourself or did someone else?
2. If someone else, do you know if they still with the company?
3. Do you know what features you are using? Just inventory?
4. Please look for these flows in particular and see when they last ran successfully
   • Admin | Sync Audit Logs
   • Admin | Sync Template v3

As an aside, if you are able to iterate directly in GitHub, with responses as well, that makes your answers much easier to see.

[SomarajuA]

Hi Jenifer,

Please see the below details.

Did you install the kit yourself or did someone else? It is installed with service account: SVC-global-PPlatform@manpowergroupapps.onmicrosoft.com. With the help of MS support team, the CoE starter Kit installed

If someone else, do you know if they still with the company? It is installed in end of March 2023.

Do you know what features you are using? Just inventory? We are trying to use Power BI reports from CoE starter kit for audit purpose

Please look for these flows in particular and see when they last ran successfully Admin | Sync Audit Logs ==> currently it is in turned off state. 21st May was last run and it was failed; 2nd May was last successful run Admin | Sync Template v3 ==> No run history, currently it is in turned off state. Last modified 8th May

[SomarajuA]

We need this to be resolved as soon as possible, please prioritize this

[Jenefer-Monroe]

OK your inventory has not been running then. So it makes sense that your data would be stale. I cannot help you debug on why your inventory runs got turned off since your build is so old. However I can tell you that set up has gotten much easier since then.

Since your data is not up to date anyway, I suggest you start from a clean state by doing the following

1. Delete the Center of Excellence - Audit Logs solution Note that it is deprecated anyway and we have a better solution in newer builds.
2. Delete Center of Excellence - Core Components solution
3. Download and upgrade Creator Kit https://aka.ms/creatorkit
4. Download and unzip latest Coe Starter Kit https://aka.ms/coestarterkitdownload
5. Install Center of Excellence - Core Components
6. Boot the CoE Setup and Upgrade Wizard and walk through the screens there to setup.

[Jenefer-Monroe]

After this you will have inventory in your tables and running again, you can check in the Power Platform Admin View app to see it.

Then you can setup the Power BI as well: Set up the Power BI dashboard And get the new Audit Log system going: Collect audit logs using an HTTP action

[SomarajuA]

Hi Jenefer, We need your help while we are doing these steps as these looks like major changes. Please let us know if you can connect with us in a call and we will do this in screen share. Thanks.

[Jenefer-Monroe]

Hello, please note the CoE Starter Kit is an unsupported set of templates: https://docs.microsoft.com/en-us/power-platform/guidance/coe/feedback-support

We are a very small, 2 person team, who try to help with all 10k installs of the kit. We do best effort to respond here to requests for assistance but we are not staffed to do calls with our GitHub customers.

Most people are able to get the kit up and running though so I'm sure you can. All you have to do in your situation is first delete what you have, or spin up a fresh environment. Please try the above steps in order and let me know if you get stuck.

[Jenefer-Monroe]

closing out as no further action for starter kit team. Please do return here with a new bug though if you try the steps and get stuck.

[SomarajuA]

Hi Jenefer, we are trying follow the steps provided.

When we are executing the center of excellence setup wizard, we are not able to turn on the below Run inventory flows and getting the below error. Please suggest.

Turn on failed. Flow client error returned with status code "BadRequest" and details "{"error":{"code":"XrmEnvironmentVariableAttributeNotFound","message":"Attribute 'value' was not found for environment variable 'admin_PowerPlatformMakeSecurityGroup'."}}".