Request to be able to grab (copy) the rows in a table!

[bonjourposte]

I have a table that I can filter in different ways in Power BI, and I want to be able to copy and paste the resulting table quickly into Excel.  (No, I don't want to download the table into csv and then convert to Excel- that takes too long for what we're trying to do).  Because we have to do a bunch of groupings for each of our borrowers depending on criteria and make their own mini tables, I'd love it if we could filter, right-click on the table, and the menu give us the option of copying all the rows in the filtered table, which we'd then paste into Excel (with the header).

If that's not an option, it would be GREAT if we could click on the top row, hold down shift key, and click on the last row, and then select "Copy Selection". 

Or, failing that, let us lassoo the rows!

It would be a HUGE time saver!

Thanks!

[v-ssriganesh · Accepted solution]

Hi @bonjourposte,
Thank you for reaching out to the Microsoft Fabric Forum Community. we completely understand the need for a quick, user-friendly way to copy filtered rows from a table visual directly into Excel, especially in dynamic reporting scenarios like yours.

Great suggestion by @GilbertQ connecting Excel directly to the Power BI semantic model is indeed a powerful and flexible alternative. It allows you to:

• Build pivot tables using the same data model as your report
• Filter and group data as needed
• Easily copy/paste the output into other Excel files
• Refresh data with a single click

Your request for a native “Copy all visible rows” (with headers) option from table visuals is very valid. We recommend submitting or upvoting this idea on the Fabric Ideas site:
Fabric Ideas - Microsoft Fabric Community

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[bonjourposte]

I've submitted the idea, thanks.

[v-ssriganesh]

Hi @bonjourposte,
That's wonderful. Thank you for taking the time to submit the idea.

Your input plays an important role in shaping future improvements to the Power BI and Microsoft Fabric experience.

If you found this response helpful, please consider clicking “Accept as Solution”. This not only helps other community members with similar needs find answers more easily but also makes your idea easier to discover and upvote increasing the chances for the Microsoft product team to review and potentially implement it in future updates.

Thank you again for contributing to the community.

[GilbertQ]

Hi @bonjourposte 

What about another option is where you can connect to the semantic model directly with Excel so you can then create your pivot table in Excel which you can then copy and paste easily into another Excel file and when you need to update the data you then just go to your Excel file and click on refresh to get the latest data. That could be an alternative way to get this working. Power BI semantic model experience in Excel - Power BI | Microsoft Learn

[bonjourposte]

@GilbertQ : Haha that's what I'm moving us away from.  We currently do that, but the filtering is so much faster in PBI, I'd rather do it there.