Forum Discussion
Automating Exporting PDFs with slicers
TimWilliam I don't think this level of granularity is supported out of the box; however should be quite straightforward to acheive using PowerAutomate, do you have licenses for this?
At a very high-level, you could create a lookup table/list with your parameter combinations and then loop through this over the specified page(s) in your report and apply the filters via URL parameters.
The output could be named however you want to define it using values from your table/list.
Without PowerAutomate, I'm not too sure, there may be a 3rd party PowerBI tool out there that does the trick.
Hi,
Happy to use power automate. Havent got a bought licence of power automate but I can purchase if I know it will work, I have a pro bi licence do I need a pro automate licence? I dont know if you or someone can point me to the steps to get it working on automate as I did mess about before and wasnt succesful.
Or do i need to go on an automate forum?
thanks,
T
The principle will undoubtedly work but a lot will depend on your specific organisational context i.e. if you're using SharePoint or Office 365, that can be the source of your 'list' whereas SQL/Oracle would carry additional costs that aren't strictly necessary (though this is what I tend to use).
The basic actions are here: Export and email a report with Power Automate - Power BI | Microsoft Docs
The additional work you'd need to do is to test passing the values as parameters in the URL and then re-creating the equivalent in the PowerAutomate action.
This post here looks to cover it broadly: Filter & Email Power BI Report pages using Power Automate & Excel – Wise Data Decisions
Hi TimWilliam. Your question inspired us at Slideform to implement this capability. Slideform is a report automation platform that can fill in and generate your reports from Power BI automatically on demand or on a schedule. We are happy to announce that we can generate a catch of reports based on different Power BI slicer values. Check it out if this is still a problem you need to solve. https://slideform.co/blog/automate-reports-with-power-bi-slicers
