WALTER on 12 Jul 2016 18:08:52
I have volumes of information to share with my teams that is best presented in tables and matrices. It would be a huge improvement if they were able to export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.
This would be especially helpful for ongoing forecasting activities.
Administrator on 13 May 2023 12:04:57
Feature has been released in public preview.
- Comments (819)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
YES
We should be allowed to export what we see in the format that we see it in and not in some other form that is basically not functional
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
YES!!! PLEASE!!!!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
As many have said before, this is very important for the report consumer to be able to export data in the same format as visual.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
I really need this feature too!!! I need to export formatted data to my boss spreadsheet Excel. I can't oblige him to adopt power-BI
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Financial Industry keenly need this functionality.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
REST API for that needed!!!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Seriously, this is prohibiting adoption in finance A LOT. Excel is still the most useful tool for some cases, e.g. those that require manual corrections. Ofc it is better to right the issue at the source but this rarely happens 100% of the time, while board reporting has to be 100% right all of the time. Fix this please.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is a deal-breaker for me to adopt Power BI for my company. We send out operational bond reconciliation reports to external parties. Since Excel is the ubiquitous format for securities operations workers, they are produced in Excel.
The Excel reports use array formulas to bring data into the desired cells. However, we need to manage ordinary reporting aspects like a variable number of bonds by providing the maximum comparisons possible, followed by deletions of blank rows for collections of bonds that number less than the maximum. I was hoping to use Power BI to get out of the need to manage those ordinary mundane reporting conditions by having
Power BI render the reconciliation datasets to the desired comparison format for as many bonds as necessary.
If I can't export the Power BI report as is to Excel, then Power BI doesn't minimize our work.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
In september 2018 desktop-update copy functionality is added, but unfortunately not this one. Please add it. It's a must have.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Excellent suggestion - this is a key gap for financial reporting