Question:
I’m using Power Automate to export a Power BI report to PDF per user (PPU workaround for dynamic subscriptions).
Flow:
Recurrence → Excel (dept_show, email) → Apply to each → Export to File → Delay → Send email
Issue:
PDF is generated and emailed, but filters are ignored — always returns full report.
Tried:
Example:
[
{
"table": "dim Dept",
"column": "department",
"operator": "In",
"values": ["10120"]
}
]
Result:
Export works, but no filtering applied at all
Question:
Is this a limitation of the Export API (especially for measure-driven reports), or am I missing something?
Thanks!
