microsoft / coe-starter-kit

Other
737 stars 216 forks source link

[CoE Starter Kit - BUG] I have issues in COE dashboard #8618

Closed Vishruth586 closed 1 month ago

Vishruth586 commented 1 month ago

Does this bug already exist in our backlog?

Describe the issue

I have installed COE kit in our tenant, however when i open the Dashboard PowerPlatformGovernance_CoEDashboard_May2024 all the pages are not loading in the Power BI application. I need some assistance here. screenshot_pages_2 screenshot_pages_1

Expected Behavior

Not able to see the pages in the Dashboard in Power BI

What solution are you experiencing the issue with?

Core

What solution version are you using?

1.3.20

What app or flow are you having the issue with?

Dashboard PowerPlatformGovernance_CoEDashboard_May2024

What method are you using to get inventory and telemetry?

None

Steps To Reproduce

Not able to see the pages in the Dashboard in Power BI

Anything else?

Not able to see the pages in the Dashboard in Power BI

AB#3831

Jenefer-Monroe commented 1 month ago

Hello. Blanks are expected for some cases in the Governance Dashboard, thats how PBI shows zeros. So you will need to find if those cases are incorrect. Let's focus in this issue instead on the Production_CoEDashboard

For the apps overview page in Production_CoEDashboard

  1. Please view the Power Platform Admin View app, do you see data there for apps? image

  2. In the PBI, please validate that you have entered the URL for your envt correctly including prefix and ending slash. image image

  3. Are other screens in the PBI showing data? Ex Environments

Vishruth586 commented 1 month ago

Hi Jenefer

Thanks for your response. If we can connect for a call and discuss it would be great.

Regards VISHRUTH KM

On Tue, 9 Jul, 2024, 19:17 Jenefer Monroe, @.***> wrote:

Hello. Blanks are expected for some cases in the Governance Dashboard, thats how PBI shows zeros. So you will need to find if those cases are incorrect. Let's focus in this issue instead on the Production_CoEDashboard

For the apps overview page in Production_CoEDashboard

1.

Please view the Power Platform Admin View app, do you see data there for apps? image.png (view on web) https://github.com/microsoft/coe-starter-kit/assets/89584709/f37bd3c7-66ab-46bd-a19b-53fdd9df8dd6 2.

In the PBI, please validate that you have entered the URL for your envt correctly including prefix and ending slash. image.png (view on web) https://github.com/microsoft/coe-starter-kit/assets/89584709/ed605483-330a-434f-b83f-c5ccb3d884c6 image.png (view on web) https://github.com/microsoft/coe-starter-kit/assets/89584709/1caa55a2-14e7-4336-860f-5dbcc1576e1a 3.

Are other screens in the PBI showing data? Ex Environments

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

Jenefer-Monroe commented 1 month ago

Hello, sorry we are not staffed to have calls with our GitHub users. Please do try the above and let me know what you see.

Vishruth586 commented 1 month ago

Hi Jenefer,

Could you please guide me on how to navigate to this page in our tenant, I tried to look out couldn't find the same.

Regards Vishruth

On Fri, 12 Jul, 2024, 17:41 Jenefer Monroe, @.***> wrote:

Hello, sorry we are not staffed to have calls with our GitHub users. Please do try the above and let me know what you see.

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

Jenefer-Monroe commented 1 month ago

This is one of the main apps you'll use in the kit. You can find more information about the app here: Power Platform Admin View

You'll find it in the solution file: image

Vishruth586 commented 1 month ago

Hi Jenefer,

I could see this

Please let me know if u need any further information

Regards Vishruth

On Mon, 15 Jul, 2024, 18:28 Jenefer Monroe, @.***> wrote:

This is one of the main apps you'll use in the kit. You can find more information about the app here: Power Platform Admin View https://learn.microsoft.com/power-platform/guidance/coe/core-components#power-platform-admin-view

You'll find it in the solution file: image.png (view on web) https://github.com/user-attachments/assets/13f75b6e-d667-43b4-82e3-2ba3f10a69d1

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

Jenefer-Monroe commented 1 month ago

Please confirm, so you booted the Power Platform Admin View app and see data for apps there?

Vishruth586 commented 1 month ago

No I have not booted.

On Thu, 18 Jul, 2024, 17:52 Jenefer Monroe, @.***> wrote:

Please confirm, so you booted the Power Platform Admin View app and see data for apps there?

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

Vishruth586 commented 1 month ago

I went to the app which you had mentioned and went on play it and the page viewed which I shared in my previous email.

On Thu, 18 Jul, 2024, 17:52 Jenefer Monroe, @.***> wrote:

Please confirm, so you booted the Power Platform Admin View app and see data for apps there?

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

Jenefer-Monroe commented 1 month ago

Sorry I'm not seeing a screenshot. Do you see data in the Power Platform Admin View app? image

Vishruth586 commented 1 month ago

This is what I see

On Thu, 18 Jul, 2024, 21:10 Jenefer Monroe, @.***> wrote:

Sorry I'm not seeing a screenshot. Do you see data in the Power Platform Admin View app? image.png (view on web) https://github.com/microsoft/coe-starter-kit/assets/89584709/f37bd3c7-66ab-46bd-a19b-53fdd9df8dd6

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

Jenefer-Monroe commented 1 month ago

ok good. So you have data. Now return to the Power BI

  1. In the PBI, please validate that you have entered the URL for your envt correctly including prefix and ending slash. image image

  2. Are other screens in the PBI showing data? Ex Environments

Vishruth586 commented 1 month ago

I could see pages with data in default environment page.

On Thu, 18 Jul, 2024, 21:37 Jenefer Monroe, @.***> wrote:

ok good. So you have data. Now return to the Power BI

1.

In the PBI, please validate that you have entered the URL for your envt correctly including prefix and ending slash. image.png (view on web) https://github.com/microsoft/coe-starter-kit/assets/89584709/ed605483-330a-434f-b83f-c5ccb3d884c6 image.png (view on web) https://github.com/microsoft/coe-starter-kit/assets/89584709/1caa55a2-14e7-4336-860f-5dbcc1576e1a 2.

Are other screens in the PBI showing data? Ex Environments

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

Vishruth586 commented 1 month ago

Also when I try to refresh data in PowerBi. I get these errors Could u please advice

On Fri, 19 Jul, 2024, 13:55 Vishruth K M, @.***> wrote:

I could see pages with data in default environment page.

On Thu, 18 Jul, 2024, 21:37 Jenefer Monroe, @.***> wrote:

ok good. So you have data. Now return to the Power BI

1.

In the PBI, please validate that you have entered the URL for your envt correctly including prefix and ending slash. image.png (view on web) https://github.com/microsoft/coe-starter-kit/assets/89584709/ed605483-330a-434f-b83f-c5ccb3d884c6 image.png (view on web) https://github.com/microsoft/coe-starter-kit/assets/89584709/1caa55a2-14e7-4336-860f-5dbcc1576e1a 2.

Are other screens in the PBI showing data? Ex Environments

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

Jenefer-Monroe commented 1 month ago

Hello. those would likely be the causing errors. However I cannot see them. Note that you need to log in to GitHub to share screenshots.

Vishruth586 commented 1 month ago

Kindly find the screenshots Screenshot_20240719_135606_Gallery Screenshot_20240719_135609_Gallery

Jenefer-Monroe commented 1 month ago

It sounds like you are not logged in correctly to PBI with an account that has access to the dataverse environment. I have seen PBI get stuck in the wrong permissions before. Here is what I suggest:

In Power BI > File > Options and settings > Data source settings image image

For both the radio buttons (Data sources in current file and Global permissions), hit clear permissions for everything listed image

Boot PBI again and log in as a user with permissions to the environment (ideally the identity who set it up) And try setup again.

Vishruth586 commented 1 month ago

I am still getting same error, when i click on edit permissions i get below

image in the image again i click on edit, it goes to same previous error.

Jenefer-Monroe commented 1 month ago

Sorry I'm really not sure. It appears you are having issues with PBI before our report even comes in to the picture. I can offer a few other suggestions but I'm really not able to offer very good PBI product support.

  1. Are you logged in to PBI as an identity with access to the dataverse organization
  2. Can you try to set the Privacy level to organization and hit edit?
  3. Try to clear permissions rather than edit.
Vishruth586 commented 1 month ago

I have PBI setup installed on a server, i use my elevated account and login to server and open the PBI app with same account. regards to first point i didnt understand could u please tell me more

I tried 2 & 3 nothing worked out.

Jenefer-Monroe commented 1 month ago

You installed the kit as some identity. Perhaps your own identity or something like CoEAdmin@yourorg.com Is that the id which is logged in to PBI?

Vishruth586 commented 1 month ago

Yes i have installed the kit using my elevated account in my organization and i have logged in PowerBI with the same account

Jenefer-Monroe commented 1 month ago

Unfortunately I'm not sure how to help. It appears that PBI is rejecting your credential, closing the connection. Not sure if you tried the "Clear permissions" or not but if not please do. For both the radio buttons (Data sources in current file and Global permissions), hit clear permissions for everything listed image

Vishruth586 commented 1 month ago

yes i tried to clear permissions and for global permissions i get this message image

Vishruth586 commented 1 month ago

Main problem is when i refresh data its not getting signed in with my elevated account which i used to configure COE setup

Jenefer-Monroe commented 1 month ago

Sorry I may have misread above, so you are logged in to PBI a different user than the elevated account that setup and configured the CoE?

Meaning, is it that elevated user that is signed in here? image

Vishruth586 commented 1 month ago

no i have used my elevated account only

Vishruth586 commented 1 month ago

i have used elevated account and that is only signed in the power BI app

Jenefer-Monroe commented 1 month ago

And this user is System Admin in the CoE environment correct?

Vishruth586 commented 1 month ago

yes

Jenefer-Monroe commented 1 month ago

ok I dont know how to help then. PowerBI is rejecting/closing your connection for some reason and I don't know why that could be. Perhaps its license related or some PBI setting that is configured. As I'm not a PBI expert I really don't know how to debug that further.

Vishruth586 commented 1 month ago

okay sure thank you for all your help, whom can i contact further

Jenefer-Monroe commented 1 month ago

I think you'll need to reach out to PBI product support or see if you have a local PBI expert in your organization that can help you get unblocked. Unfortunately I'm not sure the best approach forward here.

Vishruth586 commented 1 month ago

Does DLP policies cause this error in the COE

Vishruth586 commented 1 month ago

Does the DLP policy will there be any issues in getting the data

Jenefer-Monroe commented 1 month ago

No, DLP does not apply to Power BI. DLP will impact the ability to fill the inventory / use the apps / etc. But nothing about the PBI connections will be impacted.

You could try setting this privacy level to organization, that might help. image

Jenefer-Monroe commented 1 month ago

closing out as no further action for starter kit team