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
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

     

     

      • alexkarwoski's avatar
        alexkarwoski
        Frequent Visitor
        1 year ago

        Good Afternoon!

        So I am struggling with this issue currently. Can you eleborate what you mean by using the App Registration? Is this where the report will sit? And then will it work as intented? Or did you change the Flow to use the rest API instead.

         

        Thanks

    • Pzork's avatar
      Pzork
      New Member
      1 year ago

      This method worked for me I had the table name ReportLevelFilter

      semantica_dev dim_job/jobNumber eq 'P012345'

      I changed this to 
      semantica_dev_x0020_dim_job/jobNumber eq 'P012345'
      Power automate exported the pdf file correctly with page level filters applied

  • alexkarwoski's avatar
    alexkarwoski
    Frequent Visitor
    1 year ago

     

    2 seconds ago

    I have a similar problem.

     

    Currently I have three filters, two only allow for 1 selection and the other allows for multiple. Lets call them state, name and age respectively.

    Essentially what I want to do is iterate through these filters in power automate and generate a report for each state, name, age combination. For example, say state was GA, name was Alex, and age was 1,2, and 3. I want to click a Power Automate button in Power BI. I want generate the report for a certain page using Export for Power BI Report in power automate for the combinations
    GA,Alex, 1
    GA,Alex, 2
    GA,Alex, 3

    I have this all set up. And when I check the filters that were passed this is exactly what they are. However, the report is the same for all three pages. It shows the merged summary from having the multiple selections. I am on a premium capacity server, and have been stuck for a few days.

    Any thoughts?