Skip to main content

Power BI

Completed

Chart View Details with Export to Excel

Vote (945) Share
Jen Underwood's profile image

Jen Underwood on 13 Nov 2014 01:04:06

One of the most used features in other tools in this space (including Proclarity/PerformancePoint) that users LOVE is the ability to hover over a visualization and choose to View Details. A window then pops up that allows them to see the underlying details with an export details to Excel option.

Comments (107)
Jen Underwood's profile image Profile Picture

5b0d75f4 fbf2-4d97-a1da-e5ec7d50e701 on 05 Jul 2020 22:16:33

RE: Chart View Details with Export to Excel

Great if you publish, but at this time the company is tight with the data going outside the four walls. Would like to do it from the desktop as well.

Jen Underwood's profile image Profile Picture

6e46b390 a067-4681-adb5-afdbc0dad57a on 05 Jul 2020 22:16:16

RE: Chart View Details with Export to Excel

It sounds like MS are planning to introduce a decent Export to Excel type functionality with enough rows and from Desktop... Can anyone point to when this may b available?

Jen Underwood's profile image Profile Picture

4e9cb463 9881-4d18-803c-8dbad7865e75 on 05 Jul 2020 22:16:13

RE: Chart View Details with Export to Excel

Same here, need to be able to get the data out of Power BI Desktop to give to people for action.

Without that, it's not replacing Excel, not even for reporting.

Jen Underwood's profile image Profile Picture

e0aec9ce 46a4-402d-a221-b309c9c0c616 on 05 Jul 2020 22:15:59

RE: Chart View Details with Export to Excel

When will this functionality be added to BI Desktop?

Jen Underwood's profile image Profile Picture

0a12ba8e 6cd5-4f69-a54e-275d4bbff3ab on 05 Jul 2020 22:14:33

RE: Chart View Details with Export to Excel

Please add this to PowerBI desktop!. Thanks!!

Jen Underwood's profile image Profile Picture

8d1837e7 ceb1-45f9-817b-ca87992905c6 on 05 Jul 2020 22:14:33

RE: Chart View Details with Export to Excel

There should be a way to export Data from Power BI Desktop as well.

Jen Underwood's profile image Profile Picture

b63d93a8 0a32-4c86-9dca-84eec0392456 on 05 Jul 2020 22:14:31

RE: Chart View Details with Export to Excel

Great !! But limit of 10,000 is so restricted.

Since I created inventory balance report with net change for transaction type and balance for total using one measure, exporting only data source is not enough.

Can we export matrix data itself ?

Jen Underwood's profile image Profile Picture

6fe52d8c eab6-441d-9f63-7e7445976a7a on 05 Jul 2020 22:14:13

RE: Chart View Details with Export to Excel

The 10.000 row export limit makes it a bit of a 'demo-feature' since most of the datasets we use have way more rows. So, indeed a step in the right direction :)

Furtermore, being able to limit export functions should be included as well since not everyone should be able to export 10k+ rows of precious data.

Jen Underwood's profile image Profile Picture

99b7318c 643b-4c5a-98e8-830ffd91d59e on 05 Jul 2020 22:13:58

RE: Chart View Details with Export to Excel

Great !!! But I have the same problem, csv is not separated in cells correctly. I have CZECH localization. Please fix it.

Jen Underwood's profile image Profile Picture

28164cec 9c31-e711-80f4-fc15b428ab70 on 05 Jul 2020 22:13:50

RE: Chart View Details with Export to Excel

Great news but can we somehow set the regional settings in Power BI, the export csv feature does not work very well in a Swedish localization (computer with regional settings).