Forum Discussion
Power Automate Visual cannot retrieve values
Advocate II have the same issue as you.
I'm trying to use the Power Automate Visualization tool to set a trigger to export a paginated report. I get the error when I try to select the drop down menu under "Workspace".
It seems the connection is dead.
As I troubleshooted this, I realized I do not get this error when doing it through power automate's website, only in Power BI's - PA visualization tool. I think it might have to do with the connection on the Power BI's side. However I tried re-connecting using the "Add new connection" from the 3 circles located on the top right of the PA flow box but to no avail. No idea what is causing this, it just happened overnight
Advocate II found a work around for this in my situation.
Since it only works on the website (power automate). I created the trigger in power bi then saved it and then continued to work on it in the power automate website.
Amazing solution. Thanks a lot.
My issue with this solution is that the power automate data (data put into the visual) doesn't get exported with the flow once you inititiate the trigger. Have you found any solution around that ?
Here's what i mean :
All of the data I added to the power automate visual is not available in the power automate platform.
- mng
So I had that issue where my variables were not loading when doing it from the power automate website, however when I jumped back into power bi desktop and was able to load the dynamic variables there.
So basically I had to go from Power Bi -> Power Automate -> Power Bi to complete my flow.
Hopefully this helps
