web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power BI Get Multiple ...
Power Automate
Unanswered

Power BI Get Multiple Goals action not working - or really slow

(0) ShareShare
ReportReport
Posted on by

Hi, 

 

Is anyone else experiencing issues with the 'Get multiple goals' action in Power Automate?

 

We have used this action for a while, but it recently stopped working for me (I know it is Preview). 

 

The other Power BI actions work fine for me. 

 

Nielf_0-1671200106212.png

Categories:
I have the same question (0)
  • NielsSL Profile Picture
    on at

    I let the flow run, and I get this error:

     

    Nielf_0-1671204040568.png

     

  • NielsSL Profile Picture
    on at

    I think this issue might be related to the Move scorecard preview feature. 

     

    After moving a scorecard from one environment to another, the flow seems to fail. If I create a copy of the scorecard, the flow runs as expected. 

     

    Nielf_0-1671432388357.png

  • NielsSL Profile Picture
    on at

    Or maybe not. 

     

    Now I keep getting Internal

     

    Nielf_2-1671541573779.png

     

    Is anyone else experiencing the same?

     

     

  • pjosifovic Profile Picture
    15 on at

    Same here. Following to see if someone has a solution.

  • NielsSL Profile Picture
    on at

    @pjosifovic I found a workaround using the Run a query against a dataset action. 

     

    I built a tabel in Power BI with the data that I need and copied the DAX query, which I can use in my flow. It is not as dynamic as my previous solution as you need the Dataset ID of the dataset related to the scorecard (maybe you can get the dynamically but I don't know). In my case, I could create an array of the datasets (scorecards) that I need to loop through, where I normally would use the Get scorecards action. But again, that is also a preview action.

  • NielsSL Profile Picture
    on at

    I also reported this to Microsoft Support, so they are aware of the issue.

     

    Case ID: 2212200050001417

  • KMSoan Profile Picture
    8 on at

    Hey! Seeing the same thing. If I create a scorecard in its own environment it seems to work fine, but if I target a Copy of a scorecard, moved or not, it times out on internal server.  Any solution to this ever emerge?

  • NielsSL Profile Picture
    on at

    Not that I am aware of. I gave up on the Microsoft Support case and used the workaround mentioned above instead. 

     

    When the connector goes GA I expect it to be fixed. 

     

  • KMSoan Profile Picture
    8 on at

    I actually managed to get a similar solution to work last night by just running a query directly on the scorecard dataset with the method other people have recommended with compose --> parse JSON. However, when generating the schema it hit a roadblock where the sample schema was looking for an integer so I had to go in, find all the integers and type Number instead. That let the dataset pass successfully.

     

    Strangely enough, when I tried to pass the goal ID to Get a Goal, I had the same problem, but when I just changed it to Update a Goal it worked just fine! Gotta love a preview feature...

  • OW-18091501-0 Profile Picture
    4 on at
    Same for me. Any news about this issue?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 167

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard