Issue with sending data from Power BI to Power Automate

[JefersonM]

Hi everyone,

I'm experiencing an issue using the "Power Automate for Power BI" button to send some data directly to Microsoft To-Do. Since yesterday, 09/09/2024, the flow doesn't seem to be working as expected. When I check the flow history, I notice that the data is not being sent properly.

Below is a screenshot showing the before and after to illustrate the behavior I'm observing.

previously the input had data from the fields

previously the input had data from the fields

now it's empty

now it's going empty

Has anyone had this problem and resolved it? Do you have any suggestions on what might be wrong?

Thanks in advance for your help!

[Sjoshy]

This has nothing to do with filters or anything like that. I had a similar issue this week. All of a sudden my Power BI data wasn't send anymore. I compared the run history (csv) and noticed that the trigger step had changed while I didn't make any changes to it.

After doing a little digging I found the root cause:
It looks like this is a bug in the way the "new designer" mode and the old designer mode of a flow interact (save your flow). You probably started the creation of the flow from within Power BI (old mode).  If you (accidentally) open the flow in Power Automate in the "new designer" mode it looks like some settings are modified.

If you look at the first step/trigger (in the "new designer" mode) you will notice that the "Array" has gone blank even though you haven't made changes:

Change this value back to:

Save your flow and it will send data again from PowerBi.

[Ashi_]

Thanks so much

[JefersonM]

Thanks for the suggestion. However, the process to submit the data is the same as before when it was working. I simply select some items from a table and click the submit button. I even created a new dashboard with different data, but the problem persists there as well. Do you think there might be some other issue?

table and button

[lbendlin]

 I simply select some items from a table and click the submit button. 

That means nothing if the table visual fields don't filter the Power Automate visual fields.

[JefersonM · Accepted solution]

Thanks for your help! After running some tests, I realized that it is necessary to select at least some data from Power BI at some stage of the flow, so it starts sending. Now it is working as expected. Thank you for your help!

[lbendlin]

That's just the receiving end. First make sure that Power BI is actually sending data over.  Check your filters.