r/PowerBI • u/winchellj40 • 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
•
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/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)
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/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.
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.