Unable to see many visuals for Power Platform Administration Planning Power BI report

microsoft / coe-starter-kit

Other

749 stars 221 forks source link

Unable to see many visuals for Power Platform Administration Planning Power BI report #6253

Closed girishuppal closed 1 year ago

girishuppal commented 1 year ago

Does this bug already exist in our backlog?

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

Describe the issue

The columns defined for the visuals are missing in the data model. Please find some of the details missing

Expected Behavior

The Administration Planning report should load correctly and get updated with the Aug 2023 release

What solution are you experiencing the issue with?

Core

What solution version are you using?

Administration Planning Dashboard

What app or flow are you having the issue with?

Aug 2023 _ Power BI Dashboard

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

Open the PP Admin Planning pbit file from Aug 2023 setup and Provide environment url without prefix (https://) and postfix (/) details

Anything else?

No response

Jenefer-Monroe commented 1 year ago

I do repro this. Many visuals cannot find their field. Sending to area owner.

manuelap-msft commented 1 year ago

We haven't updated this Power BI dashboard and the data model in a long time (not since the initial release sometime last year). Likely a change in Power BI Desktop has caused some issues here. We're investigating how to update this.

manuelap-msft commented 1 year ago

Could you please check to see if this version works for you now: https://github.com/microsoft/coe-starter-kit/blob/main/CenterofExcellenceResources/Release/Collateral/CoEStarterKit/Power%20Platform%20Administration%20Planning.pbit

Thank you!

(The issue is due to how the PBI Dataverse connector returns fields for the data mapping. It used to return the unique name of a field, e.g. pcat_admintask, and now returns the display name, e.g. Admin Task. We have updated the PBIT file to point the visuals to the new names.)

girishuppal commented 1 year ago

Perfect !!! I tried loading the new PBIT file and published it to my PBI Workspace. It worked perfectly fine. Thanks for the quick turn around. Much appreciated.

manuelap-msft commented 1 year ago

Wonderful, thanks for confirming that so quickly and alerting us this issue! We didn't test those two dashboard recently as we haven't made any changes in that area, and got caught out by a product change here! Thanks for letting us know about it so we could fix it!

manuelap-msft commented 1 year ago

Closing out as this is now fixed, and the PBIT file has been updated in the release.