Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

Like (0) Share

Report

Posted on 27 Mar 2025 13:33:31 by CA-27031321-0

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

Categories:

Business Process Flows

All responses (5)

Answers (0)

lbendlin 7,906 Super User 2025 Season 1 on 27 Mar 2025 at 16:53:48

Like (0)

Report

Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

SELECTEDVALUE has no meaning in an Export scenario. Your filter values must come from somewhere else.
CA-27031321-0 4 on 27 Mar 2025 at 15:45:24

Like (0)

Report

Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

Do you know how to reference dynamic fields within that context and format?

For example, I have a measure in BI that represents the Start Date of the slicer range and updates as expected (and a very similar MAX version that represents the End Date). But I don't know how to make that valuable in the format required.

SelectedStartDate = SELECTEDVALUE('DateTable'[Date], MIN('DateTable'[Date]))
lbendlin 7,906 Super User 2025 Season 1 on 27 Mar 2025 at 15:01:28

Like (0)

Report

Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

You can put dynamic values there, but make sure they follow ISO 8601 format.
CA-27031321-0 4 on 27 Mar 2025 at 14:20:05

Like (0)

Report

Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

Thank you @lbendlin!

Your screenshot makes it seem like this would be static for 3-20-2025 to 3-26-2025 and I would need to update the filter dates within the flow every time before exporting which wouldn't be ideal. Am I interpreting that incorrectly?
lbendlin 7,906 Super User 2025 Season 1 on 27 Mar 2025 at 13:48:19

Like (1)

Report

Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

Community site session details

Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates