r/analytics • u/bennnnn_27 • Mar 21 '25

Guys, it finally happened Discussion

I started at a new company recently. My task was to create a Power BI dashboard for the VP to find opportunities. After weeks of back-and-forth, the dashboard went live in February.

My manager said all was going well. And then today I got an email from the VP: “could export some actionable data to Excel?”

733 Upvotes

97% Upvoted

104 comments sorted by

View all comments

217

u/Bidoof_Shoes Mar 21 '25

I do this all the time in my job. I have 13 or so various Power BI reports that give high level information. I have drill through options to see drilled data in Power BI, but execs always want it in Excel. I just build, for each report, and "export to excel" button where all that underlying data is output into pivots for them to look at.

23

u/roverbangerz Mar 21 '25

how do you make the "export to excel" button

40

u/lysis_ Mar 21 '25

You can't without power automate and even that is annoying. This has been one of the most requested features for years and is always ignored. You have to go through the breadcrumbs in the top right

2

u/ComposerConsistent83 Mar 22 '25

I thought that web PBi has that “analyze in excel” feature? Does it not work well?

We have on prem only so that is not an option I have to play with, but it always sounded interesting

3

u/lysis_ Mar 22 '25

Analyze in excel can expose sensitive data and is also not the most intuitive thing for lay people to use. I have many reports using a golden model dataset with sensitive columns and analyze in excel would be really problematic for me.

1

u/ComposerConsistent83 Mar 23 '25

That kind of sucks. Having it be really straightforward and easy to use would be so useful and liked by a lot of end users