Forum Discussion

Filipe_Santana's avatar
Filipe_Santana
New Member
1 year ago
Solved

Copy and past data to excel

Hi, in the latest version of Power BI desktop - Version: 2.141.1253.0 64-bit (March 2025) -

Within the table view, when I apply a filter to a table, then copy that data and paste it into Excel, the data is not coming filtered to Excel, this did not happen in the previous version. Could someone help me?

 

Portuguese:
Pessoal na ultima versão do Power BI desktop - Versão: 2.141.1253.0 64-bit (Março 2025) -
Dentro do modo de exibição de tabelas, quando eu aplico um filtro em uma tabela, depois copio esses dados e colo no Excel, os dados não estão vindo filtrados para o excel, isso não ocorria na versão anterior. Alguem poderia me ajudar?

  • Hi Filipe_Santana -You're experiencing an issue in Power BI Desktop version 2.141.1253.0 (March 2025) where copying filtered data from the Table view and pasting it into Excel results in the entire dataset being pasted, ignoring the applied filters.

    Copy and Paste Data from and into Power BI - Goodly

    Copying Table with Filters is Ignoring Filters - Microsoft Fabric Community

    Regularly check for Power BI Desktop updates, as Microsoft may release fixes for known issues.

    Hope this helps.

  • Hi Filipe_Santana ,
    Thanks for using Microsoft Fabric Community,
    The issue seems to be fixed in the April Update Version: 2.142.701.0 64-bit (April, 2025)
    I have tested this in the updated version and it worked for me
    1. Initial table while applying filters

     

    2. After filtering and copying as table

     

    3. Pasted in Excel

     

    As you can see from the above screenshots the pasted table is obeying filters in Excel.


    So please update to the latest version and try again. Hope it works.
    If you installed desktp from Microsoft Store the updates happen automatically. 
    Else you can install using this link: Download Power BI | Microsoft Power Platform

     

    If the issue persists even in the updated version, Please reach out.
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

     

    Thank you.

     

     

     

3 Replies

  • Hi Filipe_Santana -You're experiencing an issue in Power BI Desktop version 2.141.1253.0 (March 2025) where copying filtered data from the Table view and pasting it into Excel results in the entire dataset being pasted, ignoring the applied filters.

    Copy and Paste Data from and into Power BI - Goodly

    Copying Table with Filters is Ignoring Filters - Microsoft Fabric Community

    Regularly check for Power BI Desktop updates, as Microsoft may release fixes for known issues.

    Hope this helps.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support

    Hi Filipe_Santana ,
    Thanks for using Microsoft Fabric Community,
    The issue seems to be fixed in the April Update Version: 2.142.701.0 64-bit (April, 2025)
    I have tested this in the updated version and it worked for me
    1. Initial table while applying filters

     

    2. After filtering and copying as table

     

    3. Pasted in Excel

     

    As you can see from the above screenshots the pasted table is obeying filters in Excel.


    So please update to the latest version and try again. Hope it works.
    If you installed desktp from Microsoft Store the updates happen automatically. 
    Else you can install using this link: Download Power BI | Microsoft Power Platform

     

    If the issue persists even in the updated version, Please reach out.
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

     

    Thank you.

     

     

     

    • Filipe_Santana's avatar
      Filipe_Santana
      New Member

      Thank you very much for your help guys, after updating to the latest version from April 2025 the problem was resolved.