Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
My employer has disabled the export data function in our Power Bi reports. I use the "copy select" function in tables and then paste into Excel. I click and hold control while I slowly select each row, then "copy select." This is tedious with 100-300 rows in each table. Then I paste into Excel.
Is there any way to select the rows in bulk more quickly, like a control+shift+ up/down shortcut?
I need to be able to manipulate the data in Excel, so a screenshot isn't helpful. My employer will not enable the export data function. Maybe there is better workaround?
Use Power Automate to export rows from Power BI dataset to Excel
To select the whole table I right click on the firts column name and then do the copy->selection and I can paste the full table in Excel
Hi @Anonymous ,
If you still can export report as PDF, you could have a try and import the PDF file into Power BI Desktop. In this way, you could get
the data and then export it from a visualization.
If it can't work, maybe you only can select values one by one using "Ctrl + up/down + enter" or "Ctrl + Click".
Hi, thank you for your suggestion, but I don't have Power Bi Desktop. I just receive reports online. I am unable to export anything, and my employer will not enable that function.
Hi @Anonymous
Can you filter the table to show only the rows of interest, then copy-select all at once?
Can you ask report creator to create different versions of the table to only include the cells of interest -- maybe use a bookmark?
HTH
Michele
Yes, thank you, this is what I am doing. My tables are filtered and quite large, unfortunately. I'm trying to make the copy select faster-- It take at least a second for each row to be selected while I hold down control, and if I mess up and let go of control by mistake, then I have to start over until all are selected again. Just seems clunky.
Thank you, yes this is what I am doing. The copy select requires me to hold control and individually click each row until it responds and all are selected. Seems much slower than an excel sheet where I could hit control +shift. Thanks for your suggestion.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.