Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I frequently use the 'Copy Table' option to copy filtered data from Power BI to Excel. But for the past few days, when I copy the data, instead of getting only the filtered information, it copies the entire table. So instead of copying 68 rows, it ends up copying 3 million rows, and my computer doesn’t really like it.
Are other people experiencing the same issue? Do you know of any options that could help me resolve this problem?
Solved! Go to Solution.
Hi @Sehetret - I saw many users have recently reported the same issue with the 'Copy Table' option in Power BI Desktop and Power BI Service. It seems to be a bug introduced in a recent Power BI update (likely March or April 2025). Instead of copying just the filtered rows from a visual, it copies all rows from the underlying table, which can be overwhelming and crash Excel or slow down your machine.
suggestion:
You can roll back to a previous version of Power BI Desktop if this issue is critical for your workflow
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn
Reference link:
🐞New Bug in March 2025 Power BI Update – Copying Filtered Table to Excel : r/PowerBI
Copying Table with Filters is Ignoring Filters - Microsoft Fabric Community
Hope this helps.
Proud to be a Super User! | |
Hi @Sehetret ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithanya.
Hi @Sehetret ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithanya.
Hi @Sehetret ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithanya.
Hi @Sehetret ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithanya.
Dear
I have exactly the same problem, since last Friday I think. It has been a tremendous problem given by the volume of data that one handles and needs to transfer it to Excel, and using Dax is not an option since one does many different queries and filters.
I remain attentive to see if you managed to solve it.
Hi @Sehetret - I saw many users have recently reported the same issue with the 'Copy Table' option in Power BI Desktop and Power BI Service. It seems to be a bug introduced in a recent Power BI update (likely March or April 2025). Instead of copying just the filtered rows from a visual, it copies all rows from the underlying table, which can be overwhelming and crash Excel or slow down your machine.
suggestion:
You can roll back to a previous version of Power BI Desktop if this issue is critical for your workflow
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn
Reference link:
🐞New Bug in March 2025 Power BI Update – Copying Filtered Table to Excel : r/PowerBI
Copying Table with Filters is Ignoring Filters - Microsoft Fabric Community
Hope this helps.
Proud to be a Super User! | |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |