Skip to main content

Notifications

Community site session details

Community site session details

Session Id : WUdQ+3S/kHAEmspuujF/40
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 27 Mar 2025 13:33:31 by 4
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
  • lbendlin Profile Picture
    7,801 Super User 2025 Season 1 on 27 Mar 2025 at 16:53:48
    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 Profile Picture
    4 on 27 Mar 2025 at 15:45:24
    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 Profile Picture
    7,801 Super User 2025 Season 1 on 27 Mar 2025 at 15:01:28
    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 Profile Picture
    4 on 27 Mar 2025 at 14:20:05
    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 Profile Picture
    7,801 Super User 2025 Season 1 on 27 Mar 2025 at 13:48:19
    Power BI Connector - Export to File for BI Reports w/ Dynamic Date (Between) Slicer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,765 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard