on 3/18/2022 4:20:35 AM
March 2022 Update: We are looking into this
We recently released the ability to export data from tiles and visuals to a CSV file. This may work for y'all as a workaround until we add the ability to directly copy and paste the visual or data. You can read more about it here: http://blogs.msdn.com/b/powerbi/archive/2016/01/06/power-bi-service-update-0106.aspx#exportTile. Be sure to let us know what you think about the feature!
Try the Inforiver custom visual which has a feature to copy the data displayed in your visual and also have formatted Export to Excel or PDF with the entire data.
You can copy/paste the data to other application using Inforiver for Microsoft Power BI. You can also customize and export formatted statements to pdf/excel. These reports can also be scheduled to email and other destinations such as One Drive, Share Point, Teams channel etc.
please update. this is a basic function
Yeah, it's kind of crazy that end users cannot copy/paste, or otherwise export data in a way that Qlikview, Tableau, etc., has been able to do for years.
Is the MS policy simply to drive users to Report Builder/SSRS rather than throw in more xml? Having to build the visuals, measures, and format them in Power BI AND Report Builder is not efficient. Yet, this is the only way to do it Power BI. Try to convince an entire team of end users to export a custom Matrix. They'll ask you to build more in Qlikview and wonder why you're employed in Power BI.
In the Export data to xlsx feature, simply add the ability to export format's, too. Please remove Power BI's dependency on Report Builder/SSRS.
Come on guys, we're now in 2021 and we still can't copy the underlying data. If it really is so difficult to implement please explain it to us instead of ignoring this request.
Still only planned? Really? This feature is so essential I couldn't imagine that it is not yet implemented...
All the workarounds are so silly and unsatisfying - not really professional. Please implement that - can't be a huge thing.
Export is not the same as copy/paste when the report is embedded to the web. Our company currently does not allow export data due to privacy concerns.
My colleague learned BI through Tableau. He says "We are trying to copy from a Microsoft product to the clipboard, why can Tableau do this so much better than Power BI?"
Please promote this feature guys! surely a quick win
Biggest problem for me is for my customers to be able to copy visuals and the data behind them into Word documents, PDFs, etc.
It's the most requested feature.
At present they have to use Snip...! So unprofessional.
If I had $5,000 per month then I could upgrade to P1 Premium and use Paginated Reports.....which, like 99% of users, I don't have that kind of money.
Wow,.. Planned and under development for 5 years?
Ok lets break this down.
1. Why do we need this feature?
A: Many END users only need copy of visualisation / data table for Excel spreadsheet or power point. They need it asap & ready for small changes.
2. Why the workaround isn´t working ?
A: Workaround loses the table style & formating during the export.
Step 1. save *.csv. step 2. Do "text to columns". Step 3. format the table. This might be really fast and easy for power users but it´s huge hurdle for some END-users.