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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Solution Sage
Solution Sage

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.