until now I used the forums to research my issues in PowerBI and successfully found solutions, but now I have no idea what is wrong:
I have a Power BIfile with some report pages. On page 2 I have a table I want to use later to visualize in an email in Power Automate. I used "run a query against a dataset" and pasted the query code in the action in the flow (copied from performance analyzer, like I'm used to). After that, I create a HTML table, compose the output so it looks good and write an email with it.
But when I run the flow, the body of the action "run a query against a dataset" returns empty. This only happens with tables that are from the second page of the PowerBI report. If I use tables or any visuals from the first page, it works well.
Did one of you already encounter that issue and if yes, did you find a solution?
Thanks in advance for any suggestion that would help!
