Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dantheman009
Regular Visitor

Power Automate Export Report to CSV With my Date Filter

I am New to Power BI I have been able to Create reports and use power automate button to export to csv and Excel. On this particular report they prefer the CSV File however they have asked me if I could add the Date Slicers selected range as a row/ column at the top of the CSV File. I don't think that is possible it being a Comma Delimited file. But I thought I would ask. If not How can I add it to my Excel file as the first row and is there a good video out there for this. If so I would like to export Column totals also.  

3 REPLIES 3
dantheman009
Regular Visitor

I have Created a Paginated Report in report builder to work around the issue and gave them everything they wanted.

dantheman009
Regular Visitor

I created two Measures called From and to that have the selected dates I don't really want to add them to the end of the rows because I have been told it makes the report to long. They want to do the least amount of editing in excel as possible. So I have been trying to get the information they need.  Exported from my report.

christinepayton
Super User
Super User

I guess you could have your flow tack on a row to the end of your CSV table as part of the flow (just appending it). If I recall correctly though, I think the built-in export functionality in visuals' ellipsis menu shows applied filters in the Excel export. That one won't do CSV from the web, though, it's an Excel table. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors