Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.


-1.png)
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Classes
Private deliveries of courses for groups
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Certification Training
Prepare and ace your next certification with CertXP.
Cheat Sheets
Quick references for when you need a little guidance.
Prag Guides
Explore our knowledge base for quick tips on syntax, functions, and more!
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Quickstarts
Hands-on training with expert-led collaborative development.
Private Training
Personalized approach for your specific training requirements
Hackathons
Use your own data to take your team's skills to the next level.
Virtual mentoring
Get there faster with your personal trainer.
Enablement
Comprehensive enterprise enablement training for your team.
Admin Hackathon
Tame your power platform environment.
Have you ever had problems with exporting Power BI data to Excel? A recent issue a client ran into was in trying to export a very wide Power BI crosstab to Excel and being able to see that data in Excel with the entire crosstab visible, as well as the ability to print it. Additionally, they wanted to be able to distribute it, ideally in an Excel format.
To do this, the options available in Power BI are PowerPoint, PDF or print. Unfortunately, these options only give you a snapshot of what is on the screen. This is a very limited option as we can’t drag over to the right and see what’s not visible on the screen.
Here’s a simple way to solve this dilemma:
This simple solution allowed us to export the data that was in the crosstab with a link at the bottom to the Excel file for the customer/user to click on that link, open the Excel file and print it. They can also copy and paste it and distribute the data as needed without having to worry about the export options.
If you have any questions about exporting Power BI data to Excel or Power BI in general, we can help. Does your business use Power BI but you're maxing out your bandwidth dealing with Power BI security, management, compliance and end user support? Our Power BI Managed Services centralize the management and architectural support, removing the burden, so you can focus on growing your business. Click below to learn more.
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment