Export filtered data from power bi to excel

[NISH72]

Hi I have following table in power bi
Name City
A. New york
B.
C. Tokyo
D. .
I want to export only those rows in Excel where the city is blank. When I add a slicer to show blank City value in table and click on export it shows can't export all values due to size limitation. But I want to export only those rows where City is blank. Thank you

[v-yingjl]

Hi @NISH72 ,

When you create a slicer to show blank city, click (..) button in the table visual and select ‘Export data’, it will export the filtered result to excel as a .CSV file:

The most important limitation you should notice is the  maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.

For further information about export data to excel, you can refer the following Microsoft document that could help you:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

AFAIK, it exports the data being used, not just what is filtered. 

Have you considered using the Analyze in Excel functionality? YOu can download the addin using the Down arrow in the service in any report. The arrow is in the upper right. Download Analyze in Excel, install, then use Excel to pull the data. It will still pull all of it, but you can create filters and only show in Excel what you want.