[CoE Starter Kit - BUG] Dataverse for Teams - Power BI COE - Missing Connectors and App/Flow Connection References

CT9235 commented 2 years ago

Describe the issue

When opening the Dataverse_CoEDashboard_yyyyMM.pbit for installing the Dataverse for Teams Center of Excellence Power BI dashboard, errors are appearing after adding the Org URL.

Screen Shot 2021-12-14 at 2 23 50 PM

Reference from Microsoft Docs https://docs.microsoft.com/en-us/power-platform/guidance/coe/setup-powerbi#which-dashboard-to-use

Expected Behavior

The Center of Excellence Power BI Dashboard for Dataverse for Teams should load all datasets including all Connection References and Connectors.

What solution are you experiencing the issue with?

Core

What solution version are you using?

3.10

What app or flow are you having the issue with?

Dataverse_CoEDashboard_yyyyMM.pbit

Steps To Reproduce

Steps 1.) Open Dataverse_CoEDashboard_yyyyMM.pbit in Power BI Desktop 2.) Add org url which is the instance URL in Teams for the environment you are working in. 3.) Let Power BI run and load data 4.) Errors occur for: App Connection Reference, Flow Connection Reference, and Connector Message: The column 'annotation' of the table wasn't found. See screenshot

Screen Shot 2021-12-14 at 2 23 50 PM

Anything else?

Note: I was able to fix the error by removing columns in Power Query but there is still no reference to any of the connectors or connection references in the dashboard after that fix.

Let me know if another bug should be added for the second issue found.

manuelap-msft commented 2 years ago

Fixing this with #1652 for the January release. If I have the dashboards ready for testing I'll upload them earlier as well and will let you know.

manuelap-msft commented 2 years ago

You can try this one: https://github.com/microsoft/coe-starter-kit/raw/coe-january/CenterofExcellenceResources/Release/Collateral/CoEStarterKit/Teams_CoEDashboard_Jan2022.pbit

Let me know if you have any feedback! This is the version we're getting ready for the January release and this issue here should be addressed!

CT9235 commented 2 years ago

Thank you so much. I’ll check this out now.

Christina Tillbrook Senior UX Consultant

[BePNA5P+eRhAAAAAAElFTkSuQmCC] Mobile: (203)213-8595 www.tallan.comhttps://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.tallan.com%2F&data=04%7C01%7Csamantha.buccheri%40tallan.com%7C6d7a2ed50980421a661708d95cc0dfcf%7Cb7c4d562d8f647eebab9b9ee602bc6f0%7C0%7C0%7C637642805726770473%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=hrAsvwoOQ8G0Q63ikiqJlHdfG254fEd651B%2FfH4oxVk%3D&reserved=0

[A close-up of a card Description automatically generated with low confidence]

From: Manuela Pichler @.> Reply-To: microsoft/coe-starter-kit @.> Date: Monday, December 20, 2021 at 8:21 AM To: microsoft/coe-starter-kit @.> Cc: "Tillbrook, Christina" @.>, Author @.***> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] Dataverse for Teams - Power BI COE - Missing Connectors and App/Flow Connection References (Issue #1630)

[EXTERNAL EMAIL: Exercise Caution]

You can try this one: https://github.com/microsoft/coe-starter-kit/raw/coe-january/CenterofExcellenceResources/Release/Collateral/CoEStarterKit/Teams_CoEDashboard_Jan2022.pbit

Let me know if you have any feedback! This is the version we're getting ready for the January release and this issue here should be addressed!

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/coe-starter-kit/issues/1630#issuecomment-997920135, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ATB4P6J44UKEJM6MVLU2ILDUR4UVRANCNFSM5KB2ZV6Q. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you authored the thread.Message ID: @.***>

CT9235 commented 2 years ago

Hi – there are still problems with the COE dashboard, should I write up a new bug?

Christina

Christina Tillbrook Senior UX Consultant

[BePNA5P+eRhAAAAAAElFTkSuQmCC] Mobile: (203)213-8595 www.tallan.comhttps://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.tallan.com%2F&data=04%7C01%7Csamantha.buccheri%40tallan.com%7C6d7a2ed50980421a661708d95cc0dfcf%7Cb7c4d562d8f647eebab9b9ee602bc6f0%7C0%7C0%7C637642805726770473%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=hrAsvwoOQ8G0Q63ikiqJlHdfG254fEd651B%2FfH4oxVk%3D&reserved=0

[A close-up of a card Description automatically generated with low confidence]

From: "Tillbrook, Christina" @.> Date: Tuesday, December 21, 2021 at 9:47 AM To: microsoft/coe-starter-kit @.>, microsoft/coe-starter-kit @.> Cc: Author @.> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] Dataverse for Teams - Power BI COE - Missing Connectors and App/Flow Connection References (Issue #1630)

Thank you so much. I’ll check this out now.

Christina Tillbrook Senior UX Consultant

[BePNA5P+eRhAAAAAAElFTkSuQmCC] Mobile: (203)213-8595 www.tallan.comhttps://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.tallan.com%2F&data=04%7C01%7Csamantha.buccheri%40tallan.com%7C6d7a2ed50980421a661708d95cc0dfcf%7Cb7c4d562d8f647eebab9b9ee602bc6f0%7C0%7C0%7C637642805726770473%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=hrAsvwoOQ8G0Q63ikiqJlHdfG254fEd651B%2FfH4oxVk%3D&reserved=0

[A close-up of a card Description automatically generated with low confidence]

From: Manuela Pichler @.> Reply-To: microsoft/coe-starter-kit @.> Date: Monday, December 20, 2021 at 8:21 AM To: microsoft/coe-starter-kit @.> Cc: "Tillbrook, Christina" @.>, Author @.***> Subject: Re: [microsoft/coe-starter-kit] [CoE Starter Kit - BUG] Dataverse for Teams - Power BI COE - Missing Connectors and App/Flow Connection References (Issue #1630)

[EXTERNAL EMAIL: Exercise Caution]

You can try this one: https://github.com/microsoft/coe-starter-kit/raw/coe-january/CenterofExcellenceResources/Release/Collateral/CoEStarterKit/Teams_CoEDashboard_Jan2022.pbit

Let me know if you have any feedback! This is the version we're getting ready for the January release and this issue here should be addressed!

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/coe-starter-kit/issues/1630#issuecomment-997920135, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ATB4P6J44UKEJM6MVLU2ILDUR4UVRANCNFSM5KB2ZV6Q. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you authored the thread.Message ID: @.***>

manuelap-msft commented 2 years ago

No, we can keep this bug open - can you describe what problems you are seeing now and share error messages please? If you are attaching screenshots, please go directly to the bug in GitHub (https://github.com/microsoft/coe-starter-kit/issues/1630) as screenshots don't come through when replying via email!

Can you also make sure you're on the latest version of Power BI Desktop https://www.microsoft.com/en-gb/download/details.aspx?id=58494

Thank you Manuela

CT9235 commented 2 years ago

Hi - Unfortunately this still has errors. The errors have now changed. See screencapture.

Errors are only for App Connection Reference and Flow Connection Reference

Screen Shot 2021-12-21 at 10 11 46 AM

manuelap-msft commented 2 years ago

another user raised this issue #1557 and confirmed that the new version fixed this.

From January onwards, we have new guidance for using our Power BI dashboard templates, so you may be using the incorrect one based on where your solution is installed:

If your CoE Starter Kit is installed in a Production environment, please use https://github.com/microsoft/coe-starter-kit/raw/coe-january/CenterofExcellenceResources/Release/Collateral/CoEStarterKit/Production_CoEDashboard_Jan2022.pbit
If your CoE Starter Kit is installed in Dataverse for Teams, please use https://github.com/microsoft/coe-starter-kit/raw/coe-january/CenterofExcellenceResources/Release/Collateral/CoEStarterKit/Teams_CoEDashboard_Jan2022.pbit

mikefactorial commented 2 years ago

@CT9235 This has been fixed in the latest release. Please install the latest version of the toolkit following the instructions for installing updates. Note that if you do not remove the unmanaged layers as described there you will not receive updates from us.

microsoft / coe-starter-kit