Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
I have Created a Paginated Report in report builder to work around the issue and gave them everything they wanted.
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.
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.
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |