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

(0) Share

Report

Posted on by NielsSL

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.

Categories:

Using connectors

I have the same question (0)

All responses (10)

Answers (0)

NielsSL on at

Like (0)

Report

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

Was this reply helpful? Yes No
NielsSL on at

Like (1)

Report

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.

Was this reply helpful? Yes No
NielsSL on at

Like (0)

Report

Or maybe not.

Now I keep getting Internal

Is anyone else experiencing the same?

Was this reply helpful? Yes No
pjosifovic 15 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NielsSL on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
NielsSL on at

Like (0)

Report

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

Case ID: 2212200050001417

Was this reply helpful? Yes No
KMSoan 8 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
NielsSL on at

Like (0)

Report

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.

Was this reply helpful? Yes No
KMSoan 8 on at

Like (0)

Report

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...

Was this reply helpful? Yes No
OW-18091501-0 4 on at

Like (0)

Report

Same for me. Any news about this issue?

Was this reply helpful? Yes No