PowerBI second page tables not available for Power Automate

[neelia00]

Hi everyone,

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!

[lbendlin]

The query for each Power BI visual considers all filters, including the filters on the visual, on the page, and on all pages.  So likely your two queries have different filters.

[neelia00]

Thanks for answering!

Queries are different, yes, but I do not have filters on the pages, only on the visuals. That is why I'm confused - if I copy and paste the visual on the first page, it works.

Same visual, same filters on visual with no filters on page on the second page = results empty.

Do I need to edit the query syntax I paste into Power Automate somehow?

Still grateful for any suggestions.

[lbendlin]

My bet is on hidden synchronized slicers that you have long forgotten about.

Anyway, can you post a sample pbix that illustrates the issue?