[CoE Starter Kit - BUG] PowerBI Dashboard Missing Fields

[christinatang-NAES]

Describe the issue

In the Power Platform Production CoE PowerBI Dashboard, I'm seeing that there is data missing that isn't carrying across. For example, under the Apps page, the fields Unique Users, Sessions, and Last Launched are blank for some reason. Another example is the Desktop flows page. Desktop flow names are blank where the creator is listed and the rows with a Desktop flow name listed is showing blank Creator, Created On, Last run fields etc.

Expected Behavior

I expected the missing fields to be populated with the correct data.

What solution are you experiencing the issue with?

Core

What solution version are you using?

3.4

What app or flow are you having the issue with?

Admin - Sync Template V3

Steps To Reproduce

No response

Anything else?

No response

[manuelap-msft]

Hello,

For unique users/sessions: Do you have the Audit Log solution set up (https://learn.microsoft.com/en-us/power-platform/guidance/coe/setup-auditlog)? This captures information about unique users and sessions and last launched dates. If this solution has not been set up, these fields will be empty. Also note that the Audit Log solution only captures data from the moment it's set up, and is not able to get past data - so you would not get information from app launches/sessions that happened before you set the solution up.

For Desktop flows: we'll investigate, that looks like a bug in how we display the data. I'll get back to you on that!

[Jenefer-Monroe]

For the desktop flow issue, I do not repro so lets see where the issue lies for you. Do you see the data correct in the dataverse tables themselves? You can see this by going to the Power Platform Admin View app

[christinatang-NAES]

Hi Jenefer,

Thanks for looking into this issue! The data is correct in the Power Platform Admin View app but not the PowerBI dashboard. @.***

Christina Tang Business Hyperautomation Lead

Direct: 425-270-6041 | Cell: 425-773-9739 @. @.> [Inline images 1] NAES Corporation 1180 NW Maple St. Suite 200, Issaquah, WA 98027

www.naes.comhttp://www.naes.com/

From: Jenefer Monroe @.> Sent: Saturday, October 1, 2022 5:55 AM To: microsoft/coe-starter-kit @.> Cc: Tang, Christina @.>; Author @.> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] PowerBI Dashboard Missing Fields (Issue #3813)

You don't often get email from @.**@.>. Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification

WARNING: This email originated from outside your organization. Do not click links or open attachments unless you recognize the sender and know the contents are safe. If you have ANY reason to doubt the authenticity of this message, contact IT before you open or click on anything.

---

For the desktop flow issue, I do not repro so lets see where the issue lies for you. Do you see the data correct in the dataverse tables themselves? You can see this by going to the Power Platform Admin View app [image]https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fuser-images.githubusercontent.com%2F89584709%2F193410537-7d00f369-c574-4358-82d1-0c2138b7dcc0.png&data=05%7C01%7Cchristina.tang%40naes.com%7C99f312f66ba74d06e45008daa3ac17d1%7Cd610928ce5e9471eb392fd7ff6fa5c34%7C1%7C0%7C638002256776388590%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=46H5SXUOGHKlQHRnMaBZp4pJvQzgeR8cqur3eoWbVeU%3D&reserved=0

- Reply to this email directly, view it on GitHubhttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fcoe-starter-kit%2Fissues%2F3813%23issuecomment-1264355665&data=05%7C01%7Cchristina.tang%40naes.com%7C99f312f66ba74d06e45008daa3ac17d1%7Cd610928ce5e9471eb392fd7ff6fa5c34%7C1%7C0%7C638002256776388590%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bPlwvpQN96WCiuRhb93fjaxrOxd9y5E6OszkCtcRRX0%3D&reserved=0, or unsubscribehttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAZVGT5DQONBAXWIC2B2CZFDWBAYAXANCNFSM6AAAAAAQZFLPOI&data=05%7C01%7Cchristina.tang%40naes.com%7C99f312f66ba74d06e45008daa3ac17d1%7Cd610928ce5e9471eb392fd7ff6fa5c34%7C1%7C0%7C638002256776388590%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=pcODPBPop9ZT4J%2B8mB%2FifAY66mtWOXQQd4apGh6zBMY%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>

[christinatang-NAES]

Hi Manuela,

I noticed that my Child Admin Sync flow was turned off so I turned it off and now I'm running into 401 error. I'm not sure why it's giving me this error when it's successfully connected to the Office 365 Management API. Is this because something was set up incorrectly during the Azure AD app registration? @.***

Thanks for looking into this,

Christina Tang Business Hyperautomation Lead

Direct: 425-270-6041 | Cell: 425-773-9739 @. @.> [Inline images 1] NAES Corporation 1180 NW Maple St. Suite 200, Issaquah, WA 98027

www.naes.comhttp://www.naes.com/

From: Manuela Pichler @.> Sent: Friday, September 30, 2022 10:52 AM To: microsoft/coe-starter-kit @.> Cc: Tang, Christina @.>; Author @.> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] PowerBI Dashboard Missing Fields (Issue #3813)

You don't often get email from @.**@.>. Learn why this is importanthttps://aka.ms/LearnAboutSenderIdentification

WARNING: This email originated from outside your organization. Do not click links or open attachments unless you recognize the sender and know the contents are safe. If you have ANY reason to doubt the authenticity of this message, contact IT before you open or click on anything.

---

Hello,

For unique users/sessions: Do you have the Audit Log solution set up (https://learn.microsoft.com/en-us/power-platform/guidance/coe/setup-auditloghttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fpower-platform%2Fguidance%2Fcoe%2Fsetup-auditlog&data=05%7C01%7Cchristina.tang%40naes.com%7C620960bc72da47b7736c08daa30c7efe%7Cd610928ce5e9471eb392fd7ff6fa5c34%7C1%7C0%7C638001571346852017%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ulb5NInTAaq4ehmUl7kN4muZMay7%2BZeKZNuUlfIlb10%3D&reserved=0)? This captures information about unique users and sessions and last launched dates. If this solution has not been set up, these fields will be empty. Also note that the Audit Log solution only captures data from the moment it's set up, and is not able to get past data - so you would not get information from app launches/sessions that happened before you set the solution up.

For Desktop flows: we'll investigate, that looks like a bug in how we display the data. I'll get back to you on that!

- Reply to this email directly, view it on GitHubhttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fcoe-starter-kit%2Fissues%2F3813%23issuecomment-1263853783&data=05%7C01%7Cchristina.tang%40naes.com%7C620960bc72da47b7736c08daa30c7efe%7Cd610928ce5e9471eb392fd7ff6fa5c34%7C1%7C0%7C638001571346852017%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=vv9G%2B5XfDt7bChXQ4sPk8fl6Sqye%2BHTH4Q5bKgSrFFw%3D&reserved=0, or unsubscribehttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAZVGT5E5PVECAJD6NUHCUL3WA4SERANCNFSM6AAAAAAQZFLPOI&data=05%7C01%7Cchristina.tang%40naes.com%7C620960bc72da47b7736c08daa30c7efe%7Cd610928ce5e9471eb392fd7ff6fa5c34%7C1%7C0%7C638001571346852017%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9fphbokzblsYuk98LVgLEmE%2BHmpbzIzO3OOXyoJq6JQ%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>

[manuelap-msft]

Hello,

yes, a 401 error typically means the custom connector has not been setup correctly or some values have expired (e.g. the client secret may have expired). Here's the setup instructions: https://learn.microsoft.com/en-us/power-platform/guidance/coe/setup-auditlog

Once you've followed them, if you still experience issues can you let me know the steps you have done, where you're seeing the issue and share a screenshot as well as that will help with further troubleshooting.

[Jenefer-Monroe]

I think the Desktop Flows issue in PBI is likely the old isSystemUser error we saw in the past which we've fixed.

[Jenefer-Monroe]

closing out as no further action for starter kit team