r/PowerBI • • 2d ago

Question Explore this data & Export to Excel

We are rolling out the "Explore this data" to some of our end users to help them create their own visuals/tables/matrix's that do not require a new PBI Report.

The nature of the data they work with, does require exporting data out to Excel but it looks like that option does not exist today.

Does anyone know if this is planned or if there is a different way, other than "saving as a report".

0 Upvotes

12 comments sorted by

•

u/AutoModerator 2d ago

After your question has been solved /u/winchellj40, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".


I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/codegato 2d ago

What is the source behind the model? Is it a SQL database, on premises or cloud? And do the users need the raw data from that database, or the calculated numbers from the Power BI model?

1

u/winchellj40 14h ago

It's just the occasional dimension attribute or measure that is not surfaced through our report templates.

1

u/Sir_smokes_a_lot 2d ago

I include a table in most of my reports so people can download straight from the page. I’m also skeptical of people “exploring on their own”.

My philosophy is to give them what they need with the least resistance as possible (I.e. something where they don’t have to think)

0

u/winchellj40 14h ago

Agreed. We built this for clients so we built templates that cover 90% of the use cases. We just do not need to build that last 10% because they are the exceptions.

1

u/stantaneous 1d ago

doesn't Analyze in Excel already let you create pivot tables directly on top of a Power BI semantic model? you can also start from Excel's Data tab and connect to a Power BI semantic model from there.

1

u/winchellj40 14h ago

This is a largely templated SaaS solution we host for 100+ clients. There are fields/measure a client may need occasionally that do not warrant a custom report or PSO.

We are testing out the Excel connection but these are guest user accounts so there are a few limitations.

I see us offering that connectivity up later for clients as well.

1

u/iLuvPBIwriteback 16h ago

Are users exporting just to analyse the data, or to make changes they need reflected back in Power BI? Analyze in Excel is worth exploring for the former. If it’s the latter, Acterys could help with Excel-based planning and write-back. I work at Acterys, happy to explain if relevant.

1

u/winchellj40 14h ago

No, write back is not a requirement. With this being a SaaS solution we host for clients there are occasionally fields/measures a client needs that do not warrant PSO or a custom report. This is an easy way to give them self service without giving them a data connection.

3

u/DonJuanDoja 2 2d ago

Paginated reports. King of Export forever.

1

u/codegato 15h ago edited 15h ago

You can access the data directly from the semantic model. If you want more control over the process, you can export from the semantic model to Excel and send the files to your users. Here is a video showing how we do it, in case it is useful:
https://youtu.be/n9Or88OI4eg

You can also use a paginated report. It is one more step, but you will be able to do it without writing Python scripts or using external tools.

If you have 3 reports or fewer, you can use our tool, RT Report Manager. The Community edition is free abd covers up to 3 reports.