Reply
Member
Posts: 94
Registered: ‎05-02-2016
Accepted Solution

Export to excel customization

Hi All,

 

I have a tabular grid which is showing top 5 records. While exporting the grid the top5 records will be exported.

 

But user want to change the exported to excel behavior, it has to export all the records not only top 5 records.


Accepted Solutions
Highlighted
Member
Posts: 94
Registered: ‎05-02-2016

Re: Export to excel customization


All Replies
Super Contributor
Posts: 1,317
Registered: ‎07-17-2016

Re: Export to excel customization

Hi @Sunkari,

 

If you had applied filters to the visualization, the exported data will export as filtered. And I don't think this is an option to change this behavior currently. For more details, you can refer to this article.

 

So I would suggest you submit your requirement on Power BI Ideas to improve Power BI on this feature. Smiley Happy

 

Regards

Highlighted
Member
Posts: 94
Registered: ‎05-02-2016

Re: Export to excel customization

Below custom grid works as workaround for my problem.

 

https://app.powerbi.com/visuals/show/PBI_CV_309E6B47_39A5_4681_808F_132AFB230860

Super Contributor
Posts: 1,317
Registered: ‎07-17-2016

Re: Export to excel customization

Hi @Sunkari,

 

Great to hear the problem got resolved! Could you accept your reply above as solution to help others who may also have the similar issue easily find the answer and close this thread? Smiley Happy

 

Regards

Member
Posts: 94
Registered: ‎05-02-2016

Re: Export to excel customization

@v-ljerr-msft: Done sir