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
S_Manish
Frequent Visitor

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.

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

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!




View solution in original post

3 REPLIES 3
v-prasare
Community Support
Community Support

@S_Manish, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

 

@Idrissshatila & @rajendraongole1 , Thanks for your promt respons

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Idrissshatila
Super User
Super User

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

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!





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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.