Forum Discussion

Bromik's avatar
Bromik
Icon for Helper I rankHelper I
2 years ago
Solved

Power automate dynamic export

I have a dashboard with some different visualization for several companies financial data. In the dashboard there is a column where I can choose which companies data to include in the current visuali...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    you need to check the output of the trigger but it's likely something like 

     

    item()?['Column1']

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You need to provide the Report Level Filters. Make sure that column actually controls the data model.

 

 

  • Bromik's avatar
    Bromik
    Icon for Helper I rankHelper I
    2 years ago

    Yeah, I provide that filter

    "filter": { "table": "Name", "column": "companies", "operator": "eq", "value": "current loop value" }. Doesn't help. How do I ensure that column controls data model?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      you cannot use eq for lists of values.  use in 

      • Bromik's avatar
        Bromik
        Icon for Helper I rankHelper I
        2 years ago

        Thanks for the responses! As I said, I am trying to filter my report based on the values in the slicer. In the slicer there are 8 values and I need to export power BI report in PDF per every value in the slicer and send it to email. As a first step, i tried to export the report with one (instead of loop for 8 values) specific value selected ( ReportLevelFilter: Table/column eq 'Value'). However, the report which I receive in email is not filtered at all and still returns the report where all values of the slicer are selected. Do you know what may be the reason for that and how to solve it?
        (Also when I tried to insert ?filter=<Table>/<column> eq <'Value'> in the URL link of my report, the page wasn't filtered.)

        The flow i currently have: