- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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-...
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:
Hope this helps
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-29-2024 03:10 AM | |||
08-09-2024 07:53 AM | |||
04-11-2024 11:28 PM | |||
05-29-2024 03:11 PM | |||
03-27-2024 10:23 PM |