Custom Excel Export

[Vamshi2020]

Hi All,

Hope Everyone good. I need a solution for the requirement mentioned below.

Iam dealing with Million records dataset which have some calculations and measures. Due to this when iam showing my data in tabular visual, iam facing a huge performance issue . So, is there any way so that we can just show minimal (2 or 3) columns in table visual, but when we export to excel, i need to get the other required columns. This is something like Custom Excel Export.

So, please let me know if this can be achievable.

Many Thanks

[Anonymous · Accepted solution]

Hi @Vamshi2020,

For this scenario, you can consider designing a table visual with summarize mode then your records will be aggregated without show with a huge amount of records.
Then you can choose the export feature with 'export underlying data' to export detailed records instead of summarized records.

Notice: export feature for both desktop and service side all existed the limits on usage.  If you want to avoid these limits, you can try to use SSMS to link to the power bi data model and use its export features.

Power bi data model instance 

SQL SERVER – Export Data From SSMS Query to Excel 
Regards,

Xiaoxin Sheng

[amitchandak]

@Vamshi2020 , You can export data using R or Python

https://www.thebiccountant.com/2018/12/29/export-data-from-power-bi-to-csv-using-python/

https://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

[Vamshi2020]

@amitchandak ,
Very thanks for reference links provided. But, these we can use when we want to export the data from desktop naa. we want to have this export scenario from service

[mahoneypat]

Visuals have a 150,000 row limit so you won't be able to export more than that using that approach.  You will need to use DAX Studio or a Paginated Report.  Why do you need to export the data?

Regards,
Pat