Reply
S_Manish
Regular Visitor
Partially syndicated - Outbound

Copy column/table in data view in power bi not working properly

Copy column in data view is not working properly (filters on the column are not being applied)
If a table has 1000 rows and  filterd rows as 50 if i copy the filtered table and paste in Excel then the result is entire table instead of 50 rows.From Past few days.
Kindly can any one help on this issue.

2 REPLIES 2
Idrissshatila
Super User
Super User

Syndicated - Outbound

Hello @S_Manish ,

 

yes note that its a bug in the current update, check the issue here
https://community.fabric.microsoft.com/t5/Issues/Copying-Table-with-Filters-is-Ignoring-Filters/idi-...

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




rajendraongole1
Super User
Super User

Syndicated - Outbound

Hi @S_Manish  - The "Copy table" option is only available in the Report View (not Data View).

You can use DAX Studio to run queries that respect filters and copy results.Alternatively, load your filtered dataset through Power Query and export it.

 

Reference:

 

 

rajendraongole1_0-1744015101447.png

 

 

Hope this helps

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)