Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Hi @astar2006 ,
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 @astar2006
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.