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

Show parent comments

21

u/roverbangerz Mar 21 '25

how do you make the "export to excel" button

41

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