Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Periodically e-mail a Power BI scorecard status

(0) ShareShare
ReportReport
Posted on by 7

Hello

 

I am using the template "Periodically e-mail a Power BI scorecard status".

 

When I test the flow, it fails at step 2 "Get multiple goals (preview)".

The config I did for this step was to select my workspace and then my scorecard.

 

The error messge is as follows:

The given key was not present in the dictionary. function: ProjectGoalValueAggregations last line: 11

 

Does anybody know what this means and how to adderss?

 

Detailed raw output from step 2:

{
    "statusCode": 500,
    "headers": {
        "Access-Control-Allow-Methods": "GET, PUT, PATCH, DELETE, POST",
        "Access-Control-Allow-Origin": "*",
        "Access-Control-Max-Age": "3600",
        "Access-Control-Expose-Headers": "*",
        "Date": "Wed, 12 Jul 2023 13:07:34 GMT",
        "Content-Length": "372",
        "Content-Type": "application/json"
    },
    "body": {
        "error": {
            "code": 500,
            "message": "The given key was not present in the dictionary. function: ProjectGoalValueAggregations last line: 11",
            "source": "flow-apim-msmanaged-na-northcentralus-01.azure-apim.net",
            "path": "choose[1]\\when[6]\\choose\\when[1]",
            "policyId": "",
            "clientRequestId": "9400008b-b547-483c-aee6-dc0fcdcb2391"
        }
    }
}
  • dutt_v Profile Picture
    7 on at
    Re: Periodically e-mail a Power BI scorecard status

     

    The first two steps of the template flow.

     

    dutt_v_1-1689167965090.png

     

     

    Below is screen shot after I do a test run.

    It fails on step 2 and then stops.

     

    dutt_v_0-1689167899882.png

     

  • ScottShearer Profile Picture
    25,218 Most Valuable Professional on at
    Re: Periodically e-mail a Power BI scorecard status

    @dutt_v 

    Please post a screen shot of your Flow to include the step where the error takes place in design view with as much detail as possible.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,026 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow