microsoft / coe-starter-kit

Other
763 stars 225 forks source link

[Data Export] Governance Dashboard doesn't shows correct Apps Last launched data #8472

Open albertocastro365 opened 5 months ago

albertocastro365 commented 5 months ago

Does this bug already exist in our backlog?

Describe the issue

In Governance Dashboard PBI I have a blank in the "Apps launched this month" visualization. I see that uses the data from Power Apps table: image

But in the CoEDashboard PBI I can see the correct data with the last launches from apps. In this case, the data used is in Power Apps Launches table image

Expected Behavior

Governance Dashboard must be have the updated data for Last launches of apps.

What solution are you experiencing the issue with?

Core

What solution version are you using?

June 2024

What app or flow are you having the issue with?

PowerPlatformGovernance_CoEDashboard_June2024.pbit

What method are you using to get inventory and telemetry?

Data Export

Steps To Reproduce

No response

Anything else?

No response

AB#3577

Jenefer-Monroe commented 5 months ago

Hello

I think the data in your Power Apps table may be wrong due to a flow not being turned on.

We moved the updating of the Power Apps table to its own flow for performance reasons and it looks like you may not have turned it on. Please validate that both these turned on: image

That will fix the issue going forward, but I have also created a one-off flow to run which will go back and fix up app information for the ones you missed while the flow was off.

Import and Turn On the flow into CoE Environment

Go to https://make.powerautomate.com/ > select your CoE Environment > My flows > Import > Import Package (Legacy) image

Upload the following flow: Fixupmissedauditlogentries_20240514131140.zip

Create the connection and Import image

When done click Open Flow to view and then back to see details and turn on. image image image

Run the flow

Click Run enter the number of days back you need to go For example if you missed 3 months of data you would put in 90 (for 90 days) image

Flow will turn off your audit logs temporarily while it does this processing. Get everything fixed, and then turn them back on.

albertocastro365 commented 5 months ago

Hi Jennefer, I have turned off these flows because I use BYODL version.

Jenefer-Monroe commented 5 months ago

oh sorry I missed that you were Data Export. Let me take a look

Jenefer-Monroe commented 5 months ago

ok yes it looks like this wasnt made to work with Data Export. Will put as a feature for that work when we get the new schema update.