Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
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
Thank you amira.
I am developing the report in power bi report builder. Can i achive same in the report builder?
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
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.
Can you explain step by step how you are building your report and how you are publishing it to the Power BI service?
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
87 | |
65 | |
50 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |