Forum Discussion

mokumar's avatar
mokumar
New Member
4 years ago

ReportLevelFilters is not working using PowerAutomate

Hi All,   I am trying to email a report with the help of PowerAutomate using the action Export To Files for Power BI Reports (more info can be found here )   that is how the action looks like wit...
Need Help
AmosHersch's avatar
AmosHersch
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Hi mokumar ,

 

When such issues happen it's most of the time has to do with the filter string itself.

The best way to sort out what's wrong in open the same report in Power BI portal, append the same filter string to the browser URL as explained here: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

Once you get it to work as expected, the exact same string (without the "?filter=" part, and no need for the URL encoding, only special characters if exists) should work when you export through Power Automate.

mukuljuyal's avatar
mukuljuyal
New Member
2 years ago

my url filter Clusterdaily/RecordDate%20gt%202023-12-23T00:00:00Z%20and%20Clusterdaily/Cluster%20eq%20'01-C'

is working fine but not working when i am using it in export through power automate 

 

Clusterdaily/RecordDate gt 2023-12-23T00:00:00Z and Clusterdaily/Cluster eq '01-C'

  • LaurenNick's avatar
    LaurenNick
    Frequent Visitor
    2 years ago

    I donyt think you can use multiple filters when exporting PBI via PowerAutomate