microsoft / coe-starter-kit

Other
722 stars 212 forks source link

[CoE Starter Kit - BUG] Missing apps for personal productivity (Default Environment) in the governance details report #8522

Open LowCode-sudo opened 2 weeks ago

LowCode-sudo commented 2 weeks ago

Does this bug already exist in our backlog?

Describe the issue

Due to an empty column in the details dataset, there are no apps displayed for the personal productivity environment. I compared it to the normal report, where it works correct. Seems like an issue with the details dataset. Flows are displayed but apps are empty, the "Environment Name" column is empty, this should be the issue. Bild

Expected Behavior

No response

What solution are you experiencing the issue with?

Core

What solution version are you using?

June2024

What app or flow are you having the issue with?

PowerPlatformGovernance_CoEDashboard_June2024

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

In the PowerPlatformGovernance_CoEDashboard_June2024 open the App Table, there you can see that the Environment Name Colum is Empty for the default Environment Apps.

Anything else?

No response

AB#3651

Jenefer-Monroe commented 2 weeks ago

The envt filter is on the page as a whole, so I dont think that is the issue. image

Can you please go look in the Power Platform Admin View to see if there is data that fits these filters? You can add related fields as shown here for things like app owner is orphan. image

Jenefer-Monroe commented 2 weeks ago

Also note that PBI shows <> instead of 0 so blank = 0

LowCode-sudo commented 2 weeks ago

Hi, the Data is there, i think there is a problem with the provided PowerBI Report. Here is a screenshot of the Table if i try to get the Environment Name by the Environments Table and link it with apps:

image image

In the first column should be the environment name. When I access it through the Production_CoEDashboard_June2024 it works. So it seems like there is an issue with the data relation in the PowerPlatformGovernance_CoEDashboard_June2024

Jenefer-Monroe commented 2 weeks ago

ok looks like we didnt transform envtid for this case. Fix is to add this replace statement in the transform = Table.ReplaceValue(#"Replaced Value","Default-","",Replacer.ReplaceText,{"Environment ID"}) image