GHD CoE Power BI Dashboard has failed to refresh.

[santanuchokda]

Does this bug already exist in our backlog?

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

Describe the issue

GHD CoE Power BI Dashboard has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. The 'admin_user' column does not exist in the rowset. Table: Power Platform User.

Expected Behavior

The error appears after the update of COE Core components from May 2022 to February 2024 version. Didn't had any errors before the update.

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.23

What app or flow are you having the issue with?

GHD CoE Power BI Dashboard

What method are you using to get inventory and telemetry?

None

Steps To Reproduce

Go to dashboard Data sets Center of excellence data set Refresh data Error

Anything else?

No response

AB#2506

[Jenefer-Monroe]

Hello. You need to have the PBIT file and the Core version match. Every time you upgrade you need to do this to overwrite the current PBI. Sometimes you may be able to get away without doing it but then you might miss new features too!

In the download file you will find PBIT files named with the month. For Feb 2024 you will see Core version 4.23 which you say you now have installed. So you will need to use its matching PBIT: _Production_CoEDashboardFebruary2024

[santanuchokda]

Thanks Jenefer. Can you please guide me the steps how to overwrite this file?

Cheers schokda

@.*** The Power of Commitment

Connect

[linkedin icon]https://www.linkedin.com/company/ghd/ [facebook icon]https://www.facebook.com/GHDGroup [twitter icon]https://twitter.com/GHDspeaks [youtube icon]https://www.youtube.com/channel/UCwUGfe6zgaddIXqA7entIwQ Please consider the environment before printing this email

From: Jenefer Monroe @.> Sent: Friday, March 8, 2024 10:20 PM To: microsoft/coe-starter-kit @.> Cc: Santanu Chokda @.>; Author @.> Subject: Re: [microsoft/coe-starter-kit] GHD CoE Power BI Dashboard has failed to refresh. (Issue #7803)

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

Hello. You need to have the PBIT file and the Core version match. Every time you upgrade you need to do this to overwrite the current PBI. Sometimes you may be able to get away without doing it but then you might miss new features too!

In the download file you will find PBIT files named with the month. For Feb 2024 you will see Core version 4.23 which you say you now have installed. So you will need to use its matching PBIT: Production_CoEDashboard_February2024

image.png (view on web)https://github.com/microsoft/coe-starter-kit/assets/89584709/9d5fdad5-c610-479e-b20d-3efc7df54895

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

CONFIDENTIALITY NOTICE: This email, including any attachments, is confidential and may be privileged. If you are not the intended recipient please notify the sender immediately, and please delete it; you should not copy it or use it for any purpose or disclose its contents to any other person. GHD and its affiliates reserve the right to monitor and modify all email communications through their networks.

[santanuchokda]

I was able to overwrite the package and error message has disappeared now. Thanks for your help!