I want to set up an automated weekly email delivery to users of a report in Power BI. Additionally, I want to filter each report by the following columns:
Machine: Collects the identifying IDs of each machine. In this case, the report may include info from one or more machines, not necessarily just one. If more than one machine is selected, the report is going to show the combined info from the machines selected.
Day: Users should be able to choose one or several days, so that if multiple days are selected, a date range is chosen. For example, the user may want to retrieve data from February 23rd to February 27th.
WorkShift: This column stores data on shifts for a specific day (morning, afternoon, and night). It is also multi-selectable, so that the user can get info from both afternoon and night shifts for a specific date range (selected previously in WorkShift variable).
A case report for these filters could be the following:
An user wants to get information from Machines 7, 10 and 12; from the last 7 days (19/02-26/02) and for morning and afternoon shifts (excluding nights).
The report may get the info from all these filters, calculate specific KPIs based in this info and retrieve the specific results displayed in the report by email.
I've tried both Subscribe to Report function in Power BI (in Fabric) and Power Automate (connected to Fabric, also), but I've gotten the following problems:
- Subscribe to Report function: this just gives me the possibility to do a simple selection, not a multi-selection. For instance, if I choose in the filters 2 machines and 4 days, this functionality sends me 8 different report emails (1 per machine and day). I want the combined info, not the info separately.
- Power Automate: I don't know how to set this multi-selection functionality in Power Automate, I just know how to send the full report.
