How to Export Power BI To Excel (5 Different Ways)

I'll show you 5 different ways to export Power BI data to excel.

Power BI Tutorial for Beginners & Excel Users

🔴Talk Power BI LIVE (Subscribe & Join) April 12, 2019
================================
===Most Popular Playlists===

⚡Power On!⚡
-Avi Singh

#PowerBI #PowerBIHowTo #PowerBIPro

[garethgriffiths]

Really interesting, didn't realise how connected Excel and Power Bi are. Thanks.

[barryvankessel]

This helped me a lot! Sometimes a customer needs to export the data and sometimes I need it myself as a developer to check the figures I get from a Power BI Report against expected results.

[christopherhastings]

Great overview!
#2 is my favorite tip!
1) Export to Excel seems dangerous, but also empowering for the analyst.
2) Power Query is the way to go because the data compression does not take place in Power Pivot.

[scottschuler]

I like to use the Data tab in Power BI desktop to do basic troubleshooting or use the copy table feature in the tab if absolutely needed to do in Excel. It's another potential way to "export".

[ajitesh_thakur]

Hi
One r important limitation to call out on the "Export underlying data": The dataset gets flattened, meaning duplicate rows are not displayed, so you will notice the fields that had numbers don't add up unless you have a measure somewhere that is summing them up.

[eldubstepterminator]

You are a legend. You helped me solve a problem!

[EdHansberry]

Great information. I wish Excel could connect to a PowerBI Dataset the same way PowerBI Desktop can. It would eliminate the hassle of configuring the Analyze in Excel installations needed to use the "Analyze in Excel" option.

[dylanarmstrong]

One thing I actually discovered was you can copy a table by right clicking on the cells and just copy it over to excel. Worked great when I started publishing BI reports but there will always be people who prefer excel instead

[sonyset]

Genius presentation.
Powerpivot is for unlimited rows export for the power users. I am OK with the lite Analysis service approach to extract.

[fatokiadeola]

Awesome! Thanks for sharing the tips. Haven't tried DAX Studio though. I used the copy table feature to "export data from PBI to excel". Super fast!

[vardhanharsha]

Thanks for an excellent video, Avi! I have a question, from #5 method how can I export data from multiple visuals?

[romitmahajan]

the Bonus hack was so cool... thank you so much!!!!

[cotokurwajest]

Great Video! Question - for #3, can you save your analysis excel with pivots and redistribute to coworkers so they can use it to refresh data? I tried and get access errors.

[supermariaworld]

Super helpful! Thank you for posting your videos. I need to tune in to your live discussion this week. See you then!

[sanetlouw]

Hi Avi, thanks for this video, its very useful information. I've tried your option 2 & 3 and it both cases the pivot does not allow any of my value items to the Values field. Why will this be and what can I do to fix this? Thanks

[hemantgs]

This is what I was looking for... you make it so easy Thanks Avi

[mehdihammadi]

Thank you Avi this is very informative and the trick to use PBI Desktop in place of Power BI service

[sunghyunpark]

Thank you so much Sir. This is what I exactly wanted

[SD-jbsp]

Is there any way to export data in excel from Matrix in Power BI as it is ? It flattens all the rows and does not spit in the same way as it is build in Power BI?

[Bullet]

Thank you for the video, it helped a lot!