[CoE Starter Kit - BUG] Power Platform Administration Planning.pbit | The key didn't match any rows in the table

GarryPope commented 5 months ago

Does this bug already exist in our backlog?

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

Describe the issue

Hello CoE Team.

I hope you are well.

I've seen this error "The key didn't match any rows in the table" on other tickets raised for other reports, but couldn't find it for the "Power Platform Administration Planning.pbit".

When I first open Power BI Desktop with the file I get this error.

I click "Refresh now" and get the below error.

When I look at the "Model view" I see this warning.

Here's a screenshot of solutions imported, as I saw you asked for this on other tickets.

PowerBI is not my strongest skill, so any help would be greatly appreciate.

Thanks very much,

Garry

Expected Behavior

Power BI report to have no errors.

What solution are you experiencing the issue with?

Admin Task Planner

What solution version are you using?

1.3.20230724.1

What app or flow are you having the issue with?

Power Platform Administration Planning.pbit

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

open Power BI Desktop with the file "Power Platform Administration Planning.pbit"
Click "Refresh now" on any notifications.
Receive the below error.

Anything else?

No response

AB#3420

Jenefer-Monroe commented 5 months ago

Hello, have you completed the setup instructions here? https://learn.microsoft.com/power-platform/guidance/coe/setup-admin-tasks-component

GarryPope commented 5 months ago

Hello @Jenefer-Monroe, Yes, all the setup steps have been completed. before I got this error. Thanks, Garry

Jenefer-Monroe commented 5 months ago

Do you see the data if you browse in the solution to the table?

If you adjust the columns do you see the Frequency column filled? Perhaps the data ingest did not map correctly?

GarryPope commented 5 months ago

Good morning @Jenefer-Monroe,

Thanks for the reply. Please see image below showing data in that column.

Thanks,

Garry

Jenefer-Monroe commented 5 months ago

Sorry I'm really not sure what happened here or how to assist. Perhaps some other field got incorrectly mapped? Can you delete the sample data and re-import, sharing a screen of your mapping?

GarryPope commented 5 months ago

Hello @Jenefer-Monroe,

Thanks for the advice.

I deleted the data and the Power BI report, then imported the data and opened the Power BI report again, and saw that it didn't ask me for the URL, so once I configured that in "Transform Data" it worked a treat.

Sorry to have wasted your time. Please close the ticket and have a good day!

Garry

Jenefer-Monroe commented 5 months ago

No worries at all, we are happy to help. So glad we got it working! Will go ahead and close but please feel free to raise other issues in the future as needed.

rmedrano2 commented 3 months ago

Just wanted to add that I ran into this issue after deploying to our test environment yesterday. I was never prompted for the environment URL. I was able to set it manually, which after doing so allowed the report to function without throwing the error. But before that was basically stuck because the report would not allow itself to be saved while the error existed.

microsoft / coe-starter-kit