Forum Discussion
Power BI data not flowing to Power Automate 'on Power BI button clicked'
This was what caused the issue in my case also, opening in the new desinger mode direct in Power Automate rather than via the Power BI Power Automate Visual edit.
I didn't have the specific settings issue with the blank Array field however deleting the On Power BI button trigger and re-adding it via the Power BI visual edit resolved the issue for me whilst doing same from within the flow in Power Apps or Power Automate directly did not.
Advocate IThis 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.
This was what caused the issue in my case also, opening in the new desinger mode direct in Power Automate rather than via the Power BI Power Automate Visual edit.
I didn't have the specific settings issue with the blank Array field however deleting the On Power BI button trigger and re-adding it via the Power BI visual edit resolved the issue for me whilst doing same from within the flow in Power Apps or Power Automate directly did not.
- lbendlin
Super User
deleting the On Power BI button trigger and re-adding it via the Power BI visual edit resolved the issueconfirmed workaround. Thank you!
