How to export Power bi Paginated Report in to CSV with Timestamp , Generated by( Username) Period-

[Gopal_PV]

Hi Folks,

I have the paginated Power bi Report CustomerSales. The parameter is Year.

The user will select Year Parameter  and Export it into CSV.

My Source is Azure Synapse Server.  I am Publishing into service.

Now i want to Export the report CSV File Name is i.e : Timestamp_UserName_2023.CSV , 24-02-2023_Adam_2023.CSV

How achive this in power bi . Can you please help me in this.

Can we achive this if we embedded this report in any Dot Net.

[AmiraBedh]

In the PBI Desktop, open your paginated report and go to "Parameters", select the Year parameter and go to the Default Values section where you need to set the default value of your parameter as = YEAR(TODAY()) > Save >Publish

In the PBI Service, go to the workspace that contains the report and click on Export and select CSV.
In the Export data to CSV, enter the following: 

=TEXT(NOW(),"dd-MM-yyyy") & "" & USERNAME() & "" & Year & ".CSV"

Then Export

[Gopal_PV]

Thank you amira.

I am developing the report in power bi report builder.  Can i achive same in the report builder?

[AmiraBedh]

In the report builder, select the parameter year and then in the properties go to "Available Values" and select None as the default value.

In the Insert tab, select a text box where you want to display your export button. In the button action choose select URL and use the following expression (this is an example): 

= "https://<YOUR_REPORT_SERVER>/PowerBIReportServer/Pages/ReportViewer.aspx?%2fCustomerSales&rs:Format=CSV&rs:Command=Render&Year=" & Parameters!Year.Value & "&rs:ClearSession=true&rs:FileExtension=csv&rs:Command=Render&rs:FileName=" & Format(Now(), "dd-MM-yyyy_hhmmss") & "" & User!UserID & "" & Parameters!Year.Value & ".csv"

<YOUR_REPORT_SERVER> : is the URL of your report server

[Gopal_PV]

Thank you amira.

If i am only publishing the report in Power BI Service. Not have  the Report  Server. Do i need server compulsory ?   i am using synpase dedicated sql as source and publishing the same to Service.

Please guide me in this.

[AmiraBedh]

Can you explain step by step how you are building your report and how you are publishing it to the Power BI service?

[Gopal_PV]

This is sample report i have taken using EnterData as Source. The requirement is same like this. I have use azure synapse anlytics server for the source. i have connectivity issue hence choosen Enterdata to show you.  User May access this report on service or Dot Net Application.