Answered

Dynamic email sending with multiple ReportLevelFilters

(0) Share

Report

Posted on by Gabriel_Pedri

I am having trouble using the "ReportLevelFilters" field in the "Export to File for Power BI Reports" step in Power Automate.

I am receiving the following log:

{
"error": {
"code": "InvalidRequest",
"message": "Export report with more than one filter is not supported"
}
}

My flow is simple, basically, I am querying my Power BI.

This table returns the report's destination emails.

Then I apply a loop to extract a file in PDF format for each email and send it via Outlook.

However, I don't know if the syntax of my ReportLevelFilters is incorrect...

What I am trying to do in this flow is not only send the report to each email filtered by their permissions but also by currency separated into 3 PDF files.

PDF 1 - BRL
PDF 2 - USD
PDF 3 - EUR

Thanks for attention !!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Gabriel_Pedri 21 on at

Like
a
(0)

Report
Copy link

Link copied!

I was researching this log and found the correct syntax on the Microsoft website.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#filter-on-multiple-fields

Even so, it generated the same error:

Without "?filter=", it basically does not filter the data.

Was this reply helpful? Yes No
Verified answer

Gabriel_Pedri 21 on at

Like
a
(0)

Report
Copy link

Link copied!

To solve my issue, I created a bookmark that selects a slicer from my dashboard, thus assigning each PDF its respective currency.

So I copied the GUID from my report's URL and placed it in the "Pages Bookmark Name - 1" field.

Was this reply helpful? Yes No