Hi All,
I have a flow built to export my Power BI report to a PDF that then feeds into a SharePoint list and goes through an approval workflow. The report is a reconciliation of accounts so it is dependent on multiple data sources linked to a Date Table that drives a between Date Slicer to select your period of review. The report will be sent for periods of time so I need the export to consider what the date filters are at the time the button is pushed to export. It seems the natural functionality is for the export to be based on the state of the data when it was published to service last.
In another forum someone had mentioned I need to setup a dynamic parameter for the dates that would replace my current date slicer and that could be referenced for use within the Report Level filters parameter of the Export to File for Power BI action in Power Automate. However, the person couldn't walk me in detail how to actually accomplish that. I don't have much experience working with parameters at all.
All help is appreciated!
Thank you in advance,
Casey