Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
NISH72
Helper IV
Helper IV

Export filtered data from power bi to excel

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
2 REPLIES 2
v-yingjl
Community Support
Community Support

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:

export data.pngresult.png

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
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.