Automate that works with slicer?

[g_georgiev444]

Hello, I have a statistic, which needs to be sent to 20 different e-mails based on the slicer data in the report. 

I know I can make the date slicers with revolving rules based on current date for example. That is good. But I still have 2 more slicers that give the higher level of sliced data. For example I have the following slicers:

- region;

- year;

- month;

- week;

-type of transport.

Year, Month, Week could be set automatically to change with passing weeks. But I cannot dinamically change the Region and Type of transport. From what I have seen from Power automate I need to have 20 copies of the report for each region and then some based on the 2 types of transport. This is insane to manage and impossible to administer with any changes.

This is why I would like to know if there is a way to make rules in Power automate (or any other possible way) that will send the 20 e-mails, but with a way to parameterize the slicers?

[otravers · Accepted solution]

Look into using Power BI URL parameters as filters:

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

You should be able to use the above in conjunction with Power Automate, but that may require you to create fairly sophisticated flows to parse and traverse your lists of regions and transports. Alternatively, Inforiver Enterprise comes with a sophisticated scheduler that leverages these URL parameters (disclosure, I'm an advisor to that company):

https://inforiver.com/enterprise/