Unanswered

Refresh a power bi dataset action modifies all list items? then fails

(0) Share

Report

Posted on by rixmcx59

158

Hello all, I found what I thought was a a simple way to refresh a Power BI dataset connected to a SharePoint Online list. The steps came from the MS Power BI Blog, there are just two steps, "When an items is created or modified" and "Refresh a dataset Power BI"

. Sounds great except it modified all the list items and then went into a loop of trying to modify items that were already being modified by the workflow. And of course all the modifying led to exceeding the threshold of refreshes.

So my question is why is it modifying all the list Items? I thought this action would trigger if a new item was created or if an existing item was edited. If I change the due date on a single list item, I would expect the data source to be refreshed to reflect the change, not to trigger a loop through all list items.

Thanks for any help on this

Richard

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

rixmcx59 158 on at

Like (0)

Report
Copy link

Link copied!

When used with the trigger "when an item or a file is modified" the action works exactly as I would expect. The flow ran 1 time and stopped, successfully refreshing the power BI dataset.

Now my question is, what kind of condition can I use to successfully halt the flow from going into a never ending loop when using "When an items is created or modified". I tried a couple of different approaches and none seem to work

Was this reply helpful? Yes No
rixmcx59 158 on at

Like (0)

Report
Copy link

Link copied!

I checked for Power Automate and SharePoint Designer flows and nothing there, this new workflow is the only one associated with this list. I thought it's worth mentioning that I had the same issue on another site with another list when using "When an items is created or modified" action, even after adding conditional logic. I ended up just using when an item is created.
I am going to try changing the trigger to"item modified" and see what happens.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@rixmcx59

Do you have other Flows that run on that list that might be updating the item causing an infinite loop?

Was this reply helpful? Yes No
rixmcx59 158 on at

Like (0)

Report
Copy link

Link copied!

Here is a link to the steps, along with screenshots https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
It's only to steps with no expressions or complex logic.
Here is the error in the first failure "Invalid dataset refresh request. Another refresh request is already executing"
Here is the failure in the last failure "Invalid dataset refresh request. Number of refresh requests in last 24 hours exceeded limit"
My question is why did the workflow have a run history with hundreds of runs when I edited only a single item.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@rixmcx59

Can you post a screen shot of your Flow? That will be a big help to those who would like to assist.

Was this reply helpful? Yes No