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
arnemenzo's avatar
arnemenzo
Frequent Visitor
2 years ago

I can't make this filter function work in Power Automate. It works well using Service URL String but when applied to Power Automate Export to File for Power BI Reports - Report Level Filters, it never worked! Spent 3 days already still no resolution.

I have applied any possible filters in the ReportLevelFilters parameters, still the generated ouput is the default view/visual room. 

  • LaurenNick's avatar
    LaurenNick
    Frequent Visitor
    2 years ago

    Can you post a snip of what you care currently doing?

     

     

     

    • arnemenzo's avatar
      arnemenzo
      Frequent Visitor
      2 years ago

      LaurenNick 

      Can you spot where the problem is?
      Table Name: Main - Rejected VIM Invoices
      Column Name: Market Area
      Exporting PNG Image: Already enabled at Tenant Level
      My PBI Workspace Access: Contributor Role

      This is just a sample but the actual case would use a dynamic filter (i.e. Country Name) which expects to generate around 100 different snapshot images per country. For illustration purposes, I'm using Market Area.

       

      • LaurenNick's avatar
        LaurenNick
        Frequent Visitor
        2 years ago

        Report Level Filter Sample 3 looks close but try adding a _x0020_ between Market and Area.

        I think I ended up creating duplicate columns in my data that didn't have the spaces as this was driving my bonkers

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    arnemenzo Bookmarking the filter state and using that instead works for me.

     

     

    • arnemenzo's avatar
      arnemenzo
      Frequent Visitor
      2 years ago

      Thank you Anonymous! Yes, indeed this is a best solution if the we're dealing with few sets of value filters. But with my case, I'm dealing for over 100 different sets of value filter. Plus, the values are dynamic (like the next day, new category is added). Report Level Filter must be the best option in this case. The thing is, I can't make it work

      Can you spot where the problem is?

      Table Name: Main - Rejected VIM Invoices
      Column Name: Market Area
      Exporting PNG Image: Already enabled at Tenant Level
      My PBI Workspace Access: Contributor Role

      This is just a sample but the actual case would use a dynamic filter (i.e. Country Name/Category Name) which expects to generate around 100 different snapshot images per country. For illustration purposes, I'm using Market Area.