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

[@barryvankessel9674]

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.

[@PowerBIPro]

Hi Barry van Kessel, Glad this video, helped you. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★

[@christopherhastings2142]

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.

[@PowerBIPro]

Yes, for #1 it's all about the balance. Too much "Export to Excel" => chaos. You shut it down (silly move!) - you're not empowering your users. When my users ask me about Exporting, I usually try to find out why they want to do it. #2 Hmmm...Power Query does not hold any data itself. It can send it to Excel or Power Pivot. If sent to Power Pivot - Power Pivot is actually a crazy beast at compressing data (Power Pivot is the same engine that runs inside Power BI as well). For one it uses "Columnar Storage" (stores by columns instead of row by row like regular DB systems) - which makes it really good at compression. It's got other tricks up it's sleeve too. See you in the next live! (On a break this week - taking a short trip with Kids. I'll be live next Friday). Power On! / Avi

[@EdHansberry]

PowerPivot is where compression takes place, and should compress the data above as it is imported. Where compression doesn't work as well is with Calculated Columns, which isn't used in these scenarios. But I agree Power Query is the best way to do this *because* you can further transform your data before bringing it in to Power Pivot. Get rid of unneeded columns, filter data by date ranges, etc.

[@garethgriffiths6620]

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

[@dylanarmstrong9328]

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

[@fatokiadeola9114]

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!

[@PowerBIPro]

Hi Fatoki Adeola, Glad it helped. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★

[@emilyjohns5085]

@@PowerBIPro I have users that want to export all columns in the data model from visuals when using powerbi.com. I notice the underlying data is not including every column in the data model, especially if I have a related table in the data model connected to my main data model table. Any advice??

[@eldubstepterminator1938]

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

[@sonyse2t5]

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

[@PowerBIPro]

Hi Wu吴 子 健. Thanks for the positive feedback. ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@mardithpascua8112]

How do you let the "Export Data" in BI online appear? It is missing in my report even though I already configured the Export Data in the settings.

[@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.

[@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.

[@PowerBIPro]

It actually can, but using the Excel Power BI Add-In. I know...an install is still needed. But once installed, you can reach out from within Excel and connect to any Power BI Data set. I realize, I should have at least mentioned this in the video :-P ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@scottschuler2234]

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".

[@PowerBIPro]

Hi Scott. Nice one! Yeah..I have used that too, but forgot about that totally. Thanks for the tip! ⚡Power On!⚡ / Avi ★ Power BI Beginner Tutorial: kzbin.info/aero/PL7GQQXV5Z8ef2SjkDpLnvsz7TAQjlzlpO ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@sherefmorad1042]

Really Helpful ... Thanks A lot

[@PowerBIPro]

Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM

[@anushakm7002]

Excellent idea

[@sanetlouw5793]

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

[@sunghyunpark2055]

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

[@vardhanharsha5764]

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

[@21Bullet]

Thank you for the video, it helped a lot!

[@nehashahpatel1741]

Millions thanks

[@PowerBIPro]

Hi Neha ShahPatel, Thanks so much for being a subscriber🙏🏻 You're welcome. ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★

[@mehdihammadi6145]

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

[@PowerBIPro]

Hi Mehdi Hammadi. You're welcome! ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@romitmahajan]

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

[@PowerBIPro]

Hi romit mahajan. Welcome! ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@lunatiko098]

Excellent video!

[@kashansamad197]

Great video, is it possible to export data from the kpi scorecards at the top, Sales for e.g?

[@hemantgs3326]

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

[@PowerBIPro]

Hi Hemant Gs. Absolutely! ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@ravikumarpa4497]

Thanks for great video..

[@vincenzo4259]

Thanks

[@jozfida]

Hello Avi, Very nice vidéos !! I just have a question that nobody can answear me : is it possible to extract on Excel all my measures ? Do u know if it is possible ? If yes, have you any tuto on that plz ? Thanks by advance for ur help and all ur videos wich are very very usefull !!!

[@marciof]

Hi, any sugestions to export Matrix to PDF Report?

[@cotokurwajest666]

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.

[@sravankumar1767]

nice explanation, in power bi reports are connected multiple datasets like pipeline, segment, forecast these are datasets how should we export to excel, if we have a single dataset we can write like evaluate sales. in power bi report connect with multiple datasets we can write according to our require at that how can we export to excel, can you please explain it..

[@lehoang226]

thank bro. love your voice at the beginning

[@karanjeetsingh2763]

A super cool video Avi 👌

[@gleahdulay]

Hello there I really like your video ☺️. Can I make a request video? Because I dont have export options in power bi and our power BI author do not allow us to export it. Is there a way that I can copy the table and put an export access to it?

[@israkvelvarga993]

You saved my life!!!!

[@PowerBIPro]

Hi israk velvarga. Wow! I’m happy to help mate! ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@supermariaworld64]

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

[@PowerBIPro]

Hi Maria Giugno Sonnemann. Thank you for the compliment! Looking forward to it. ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@oliverprodinger9666]

Hi Avi, great tutorial, thanks. My favorite is #3 connecting with Excel. But if I do this, in Excel all Fields have character datatypes, so I can not use it in pivot. Where is my mistake? #1 and #2 running without problems.

[@teresapereira6936]

Thanks for the tips!

[@PowerBIPro]

Hi Teresa Pereira. You're welcome! ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@barttitulaerexcelbart9400]

Great video Avi. Thanks a lot. I am wondering if your method will be formalized by MS or that they will prevent data download to Excel.

[@PowerBIPro]

Hey Bart, Always good to see you on the channel. Ha! My gut feel is that it would not be formalized by MS, but they would not shut it down either. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@PedroCabraldaCamara]

Great video Avi!! Thank you so much About the quiz, no doubt power query because you can "clean it" first, that is just in case you need it to

[@PowerBIPro]

Yes! The Kitchen of Power BI! That's what I call the Query Editor. Why wouldn't you do the data cleanup there :-)

[@alvaroandressuarezalfonso7842]

Thanks for the explanation. Btw Is there a way to export entire report to excel in power bi?. For example if you have multiple table in one page, can you export all those tables into one excel file?

[@davidwang8270]

awesome! thanks.

[@PowerBIPro]

Hi david wang. You're welcome! ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@SD-jb1sp]

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?

[@bvnhome]

Im using connect excel to powerbi approch, but to get the data latest data in excel we need to manually open and refresh right

[@meysamseyahtiri3919]

Hi Avi, Thanks for the great video. really helpful. I wonder I there is a similar way to acquire the localhost but now server address when the dataset is now uploaded to the PBI services.

[@kamelhammami5252]

Great stuff, thanks Avi

[@meetpremsingh]

In PBI, Can we export Conditional Formatting data in PBI table or matrix to Excel. We need to keep Conditional formatting data intact.

[@theakashraj]

Thanks for sharing the video. One question - I am unable to download the 'totals' while exporting the summarized data from the visual. Is there any way to download the totals as well along with the summarized data?

[@alifadhul7]

Thanks, I am looking for a way to export ALL charts in power BI dashboard to CSV in one click. Still didn't see any solution to do it!

[@PowerBIPro]

Ali, have you tried Export to PDF: docs.microsoft.com/en-us/power-bi/consumer/end-user-pdf?tabs=powerbi-service If you have any additional questions or need further help you can also join our live events: 👉 www.TalkPowerBI.com --Or-- 👉 Consider joining our LearnPowerBI Training Program www.learnpowerbi.com/training Power On! / Avi

[@aratikanvinde1645]

How do u export hyperlink from power bi visuals to excel - all data gets exported but hyperlink from field is post

[@aratikanvinde1645]

Hyperinks are lost during excel export

[@scientifically5812]

Great video. Thank you. Is it possible to export data through PowerBI REST API?

[@mohitsaini5542]

So the question is: like in a power bi page there are 2-3 charts and 2-3 filters. If we select any filter all the other charts and filters show different values. So when the filter is selected, I wanted to export that data in an excel file which will tell all the values from charts and filters. Is it possible? To be more clear - let's take the example of Adventure works in the video. So if we select the single month and then I want to export the whole data present on the page in one click, is it possible?

[@ravijella1730]

Hey buddy.. After publishing to web, i cant see option to export to excel.. can you please help me how to get the option after publishing to web.. Thanks in advance

[@randallmurillo5373]

It's possible to change the extension of csv for export data in PBI?

[@josephnakabaale3347]

Hello is it possible for a powerbi report be exported to excel with several sheets/tabs?

[@PowerBIPro]

Marianne from Team Avi. Sorry Avi, was not able to get to your comment. If you're still stuck and need help we would recommend submitting the question to our LIVE TalkPowerBI Q&A Session www.learnpowerbi.com/talkpowerbi#qa

[@josephnakabaale3347]

@@PowerBIPro my question is never answered and am still stuck , and i still need help on the issue of multiple tab/sheet Excel export in powerbi.

[@takurafelixmavatu7124]

did you manage to get any solution @Joseph

[@jacksonhz]

Great vídeo, as always very helpful!

[@colonelzorro]

HI, Excellent video, im new to power bi and learning a lot from your channel. i have a question, im trying the third method, however when it generates the dynamic table on excel, it doesnt let me put the values on the value area only on rows, columns or filters. is there any reason for this to happen?

[@saurabhsharma5938]

Great Video, Thank you for posting, BUT while performing "Combine and Transform" rows with data is missing, any suggestions?

[@davidjosephaguilar3448]

Very helpful vid! Q: is it possible to schedule an export of the data from PBI desktop to excel without DAX Studio? thanks!

[@reubenjustice9657]

I guess it is kinda off topic but does anybody know a good site to stream new tv shows online?

[@kabirkhalid2499]

@Reuben Justice I watch on flixzone. Just google for it :)

[@loganjonah9575]

@Kabir Khalid Yup, have been watching on flixzone for years myself :D

[@reubenjustice9657]

@Kabir Khalid thanks, I went there and it seems to work :) I appreciate it!

[@kabirkhalid2499]

@Reuben Justice You are welcome =)

[@stephenbrincat7124]

Amazing, well done Avi

[@anvishlok]

HI Avi I have a small problem. 1st I would like to explain what I did. So I am managing my teamwork via using Trello board but it is sometimes tricky to see new entries. So what I did. I export/print Trello data in JSON file and link it with BI ( of course I cleaned all unnecessary columns ). after clean-up the report, I made a table with my required columns. But when I am exporting that data in excel, I am getting only 20% data over there. will you please help me out with this issue?

[@donaldzeroinc]

is there a way to show the picture from table visual, when export to excel? instead of showing the URL link?

[@PrideEnchantaVagale]

Great. Thanks for the video. Is there any option to export from power bi service to sql server table?

[@PowerBIPro]

Hmmm...I'm not sure if that's possible directly. May be indirectly Power BI Service => Excel => SQL And you can likely automate the whole thing using a 3rd party tool like Power Update. (You can ask me more in one of our LIVE TalkPowerBI shows) - link below. ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@jobelleposadas3456]

Hi, Avi! Can you help me how to export million rows data from a published report? I'm not the author of the report but I need the dataset for further analyzation. Hope you can help me. Thank you.

[@NoCompM2]

Avi, I am trying the #4 method and the export data option is not available for me to click.

[@jaanaan2847]

Hi, but some data will be missed during transferring to excel , how to fix this?

[@manikandanj255]

Hi, I have one master excel template. Is it possible to extract specific power bi visual to the master excel template using macro coding?

[@mjosic]

Nice touch, Avi! How about using Python/R to export data from Power Query? Or use Copy Table in the data model?

[@PowerBIPro]

Mislav, love that. Hey, tell me. bit more. What is the business scenario in which it would make sense to export data using Python/R from Power Query? One scenario that I had heard was to also take a snapshot of data as it's refreshed. Would love to hear what specific scenario you have in mind.

[@mjosic]

@@PowerBIPro Like doing ETL in PowerQuery and them exporting the results to csv via Python script (3 lines of code).

[@OlivierTravers]

@@mjosic you can do it in PQ but then you're only seeing the source data. If you want to export the output of DAX measure or calculated columns/tables, then you can run your python or R script in a visual instead.

[@eduardomass]

Hello. I was trying to download the "pivot" table from excel from you step #3. When I download that excel in a machine that doesn't connect to the power desktop server directly, it shows an error that cannot connect to tha pbiazure://api.powerbi.com.... Do you know why is not possible to do that? Kind regrads!

[@sivakoteswararao2698]

How can we set property to run power bi report in excel instead of html format.

[@koteshsai9570]

Hi, Is end user need PowerBi Pro license to export the data ?

[@zachgould8644]

hey Avi! Do you know if there is anyway to export the PowerBi visuals into an excel file so that they can be seen while updating the excel sheet??

[@drguets]

so from power bi desktop i can't export to xlsx, only csv? I need to publish my report to powerbi service to be able to export to xlsx?

[@jonarthur590]

Does anyone know how to export Power BI data to Excel to include the totals? I can export to Excel fine, but when I do, my Grand Totals do come over with the data.

[@KLMCats]

Export to Excel - Good/Bad? In my situation, it is mostly good. The rare cases where it would not be? I simply configure the report using OPTIONS.

[@jimmyhumania]

good

[@mansikasera1153]

Please let me konw how to export power bi report charts and graphs in excel sheet

[@ValesAndTales]

Yes

[@varunatyam1669]

When exporting data to excel the number of rows are decreasing how to fix it

[@Ehsanahmad99]

Weird that there are limitations on visuals, that should be the idea of using power bi

[@AJM2183]

My company won't allow me to download DAX Query so there's no way to get millions of rows out? Because I can't get the "magic" address without it...

[@tm2535]

When would you want to download from Power BI to Excel? Why not straight from your database to Excel?

[@ahmedel-kholy8561]

I did not understand the second method, how can i export data from the powerbi.com ?

[@rksudhuman]

Export option not available in Current version BI embedded :(

[@kapudamodhar1252]

how to export data with out sampling

[@adrianapazmino4868]

For number 3 how do you open the chart ? Help please