Copying Table with Filters is Ignoring Filters

[PeterValentiAVA]

Good Day,

Occassionally I filter tables using a Table View to copy filtered results to use outside of Power BI - I.E. in Excel.

As of today it appears that when copying the Table View that has been filtered, it ignores the filters and copies the whole table. This is an issue for me as when I have a table in excess of 700,000 rows it makes this process extremely slow to copy from Power BI, and near impossible to paste it into Excel.

I have already tried uninstalling and reinstalling the program.

Is anyone else experiencing this issue?

As an example, we are a service company and we have a geographic alignment for our field service team. Simply, filtering a table by the "East" Region and trying to copy the table when filtered to the East is not working. Instead, the entire table is copied.

[ViktorS]

The same problem )! Power BI Desktop "Copy table" and "Copy Column" in Table view doesn't work any more I used "Copy table" in Table view, and tried to paste on Excel, but the table wasn't copied. It was working until yesterday (April 1). Before we can copy only data filterd - now after filter copy all data. Please fix)) 04-08-2025

[ShirinShams13]

How can we raise/Highlight this issue more? it is urgent.

[AK10938]

I am still seeing this issue as of 4.9.2025. Please fix this Power BI

[PeterValentiAVA]

So a potential workaround in the short term would be to filter directly in Query Editor and apply the changes. Then at least the entire table copied is representative of the filtered content desired. However, this is an unacceptable solution long term. Without potentially impacting reports I would recommend saving a copy of your Power BI report to use this workaround.

[PBIBel]

Rob Sargent's workaround that he mentioned in an earlier comment works for us, but it is a bit of a faff, as he says. Quicker than adding filters in Power Query if you have a lot of data as that can be slow and sometimes you don't want to refresh the data again before exporting.  The workaround is to create a table for export, and set the filters as needed. I don't know how to reference a message so copying and pasting his instructions here: click on Table tools > New table then enter some version of the following: table_filtered = FILTER(table, table[column_to_filter_on] IN {"filter_value_1", "filter_value_2", "filter_value_3"}) If you need to filter on more than one column you can use && for "and", and || for "or".

[mmyar]

Same problem for me, it's been since the beginning of the month and still not working. Super frustrating, I hope they fix it soon.

[v-veshwara-msft]

I tested this in the latest April 2025 update (Version: 2.142.701.0 64-bit), and the issue appears to be resolved—the filtered data now copies correctly to Excel.

I've shared a reference thread with screenshots demonstrating the reproduced scenario in my environment:
Re: Copy and past data to excel - Microsoft Fabric Community

If you're using the Microsoft Store version of Power BI Desktop, updates are applied automatically. Otherwise, you can manually download the latest version here:
Download Power BI | Microsoft Power Platform

[bramirez]

I FOUND A WAY TO GET WHAT I NEED EXPORTED WITH FILTERS I have been using the Report view feature to create slicers that I need to use for filtering. Then a Visualization = Table to pull in all the columns I need on my export, ensuring to select "Dont summarize" or for each and updating the Heirarchy on the date to the name of my column. Once all the columns are added, use the elypsis (...) on the top right corner of the visual to Export Data. This will open File explorer to save. Tada! I literally did the happy dance after I figured it out! Good luck!

[ShirinShams13]

It seems to me that the issue is fixed! 14/04/2025

[sparta1000]

This problem remains as of 4/14/2025 and grows more problematic by the day.