Power BI Power Automate button Reference Issue

[Mat42]

So, I asked this question on the Power Automate forum (because I was directed there with the last question I asked) but it's just sitting there all sad and lonely like Frys' dog, so I thought I'd try here and see if anyone can help. I'm horrendously new to PowerAutomate, so bear with me.

Basically, I've been using the Power Automate button to export data from a table within a PBI report to a csv and it's worked fine, but I now need to automate the process, i.e. do the same task, but from outside the report.

To create the button I basically just aded it to the report, added the columns of data I wanted, clicked 'Edit', and chose a template, winding up with something that looks like this:

Now, however, I need to be able to run this as an automatic flow, i.e. without the need for the button press, and I have little idea what I need to replace the top step with ('On Power BI button clicked') to reference the report.

I've managed to get some data out by using the 'Run a query against a dataset' option, which will actually pull data out of the report, but I can't get it to sit nicely in a csv, it just appears in a single row and nothing I do changes this. Which leads me to believe that I'm using the wrong reference options for the report, hence the question.

Any ideas?

[Mat42 · Accepted solution]

So, I figured out the problem.

Essentially, the 'Run a query against a dataset' step was correct, but the 'Compose' control that the PBI/Power Automate button generated, wasn't. I literally took that step out and it works fine.

Should have started from scratch in the first place.