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.
@PowerBIPro4 жыл бұрын
Hi Barry van Kessel, Glad this video, helped you. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
@christopherhastings21425 жыл бұрын
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.
@PowerBIPro5 жыл бұрын
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
@EdHansberry5 жыл бұрын
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.
@garethgriffiths66203 жыл бұрын
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
@fatokiadeola91144 жыл бұрын
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!
@PowerBIPro4 жыл бұрын
Hi Fatoki Adeola, Glad it helped. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★
@emilyjohns50854 жыл бұрын
@@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!
@sonyse2t55 жыл бұрын
Genius presentation. Powerpivot is for unlimited rows export for the power users. I am OK with the lite Analysis service approach to extract.
@PowerBIPro5 жыл бұрын
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_thakur4 жыл бұрын
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.
@EdHansberry5 жыл бұрын
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.
@PowerBIPro5 жыл бұрын
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 ★
@scottschuler22345 жыл бұрын
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".
@PowerBIPro5 жыл бұрын
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 ★
@sherefmorad10422 жыл бұрын
Really Helpful ... Thanks A lot
@PowerBIPro2 жыл бұрын
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
@anushakm70022 жыл бұрын
Excellent idea
@sanetlouw57932 жыл бұрын
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
@vardhanharsha57644 жыл бұрын
Thanks for an excellent video, Avi! I have a question, from #5 method how can I export data from multiple visuals?
@21Bullet3 жыл бұрын
Thank you for the video, it helped a lot!
@nehashahpatel17414 жыл бұрын
Millions thanks
@PowerBIPro4 жыл бұрын
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 ★
@mehdihammadi61454 жыл бұрын
Thank you Avi this is very informative and the trick to use PBI Desktop in place of Power BI service
@PowerBIPro4 жыл бұрын
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 ★
@romitmahajan4 жыл бұрын
the Bonus hack was so cool... thank you so much!!!!
@PowerBIPro4 жыл бұрын
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 ★
@lunatiko0983 жыл бұрын
Excellent video!
@kashansamad1973 жыл бұрын
Great video, is it possible to export data from the kpi scorecards at the top, Sales for e.g?
@hemantgs33264 жыл бұрын
This is what I was looking for... you make it so easy Thanks Avi
@PowerBIPro4 жыл бұрын
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 ★
@ravikumarpa44974 жыл бұрын
Thanks for great video..
@vincenzo42592 жыл бұрын
Thanks
@jozfida4 жыл бұрын
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 !!!
@marciof4 жыл бұрын
Hi, any sugestions to export Matrix to PDF Report?
@cotokurwajest6663 жыл бұрын
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.
@sravankumar17673 жыл бұрын
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..
@lehoang2264 жыл бұрын
thank bro. love your voice at the beginning
@karanjeetsingh27635 жыл бұрын
A super cool video Avi 👌
@gleahdulay3 жыл бұрын
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?
@israkvelvarga9935 жыл бұрын
You saved my life!!!!
@PowerBIPro5 жыл бұрын
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 ★
@supermariaworld645 жыл бұрын
Super helpful! Thank you for posting your videos. I need to tune in to your live discussion this week. See you then!
@PowerBIPro5 жыл бұрын
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 ★
@oliverprodinger96662 жыл бұрын
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.
@teresapereira69365 жыл бұрын
Thanks for the tips!
@PowerBIPro5 жыл бұрын
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 ★
@barttitulaerexcelbart94005 жыл бұрын
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.
@PowerBIPro5 жыл бұрын
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 ★
@PedroCabraldaCamara5 жыл бұрын
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
@PowerBIPro5 жыл бұрын
Yes! The Kitchen of Power BI! That's what I call the Query Editor. Why wouldn't you do the data cleanup there :-)
@alvaroandressuarezalfonso78424 жыл бұрын
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?
@davidwang82705 жыл бұрын
awesome! thanks.
@PowerBIPro5 жыл бұрын
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-jb1sp4 жыл бұрын
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?
@bvnhome2 жыл бұрын
Im using connect excel to powerbi approch, but to get the data latest data in excel we need to manually open and refresh right
@meysamseyahtiri39194 жыл бұрын
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.
@kamelhammami52524 жыл бұрын
Great stuff, thanks Avi
@meetpremsingh2 жыл бұрын
In PBI, Can we export Conditional Formatting data in PBI table or matrix to Excel. We need to keep Conditional formatting data intact.
@theakashraj3 жыл бұрын
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?
@alifadhul72 жыл бұрын
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!
@PowerBIPro2 жыл бұрын
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
@aratikanvinde16453 жыл бұрын
How do u export hyperlink from power bi visuals to excel - all data gets exported but hyperlink from field is post
@aratikanvinde16453 жыл бұрын
Hyperinks are lost during excel export
@scientifically58125 жыл бұрын
Great video. Thank you. Is it possible to export data through PowerBI REST API?
@mohitsaini55422 жыл бұрын
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?
@ravijella17304 жыл бұрын
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
@randallmurillo53734 жыл бұрын
It's possible to change the extension of csv for export data in PBI?
@josephnakabaale33474 жыл бұрын
Hello is it possible for a powerbi report be exported to excel with several sheets/tabs?
@PowerBIPro4 жыл бұрын
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
@josephnakabaale33474 жыл бұрын
@@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.
@takurafelixmavatu71243 жыл бұрын
did you manage to get any solution @Joseph
@jacksonhz5 жыл бұрын
Great vídeo, as always very helpful!
@colonelzorro4 жыл бұрын
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?
@saurabhsharma59384 жыл бұрын
Great Video, Thank you for posting, BUT while performing "Combine and Transform" rows with data is missing, any suggestions?
@davidjosephaguilar34485 жыл бұрын
Very helpful vid! Q: is it possible to schedule an export of the data from PBI desktop to excel without DAX Studio? thanks!
@reubenjustice96573 жыл бұрын
I guess it is kinda off topic but does anybody know a good site to stream new tv shows online?
@kabirkhalid24993 жыл бұрын
@Reuben Justice I watch on flixzone. Just google for it :)
@loganjonah95753 жыл бұрын
@Kabir Khalid Yup, have been watching on flixzone for years myself :D
@reubenjustice96573 жыл бұрын
@Kabir Khalid thanks, I went there and it seems to work :) I appreciate it!
@kabirkhalid24993 жыл бұрын
@Reuben Justice You are welcome =)
@stephenbrincat71245 жыл бұрын
Amazing, well done Avi
@anvishlok3 жыл бұрын
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?
@donaldzeroinc4 жыл бұрын
is there a way to show the picture from table visual, when export to excel? instead of showing the URL link?
@PrideEnchantaVagale5 жыл бұрын
Great. Thanks for the video. Is there any option to export from power bi service to sql server table?
@PowerBIPro5 жыл бұрын
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 ★
@jobelleposadas34564 жыл бұрын
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.
@NoCompM24 жыл бұрын
Avi, I am trying the #4 method and the export data option is not available for me to click.
@jaanaan28472 жыл бұрын
Hi, but some data will be missed during transferring to excel , how to fix this?
@manikandanj2554 жыл бұрын
Hi, I have one master excel template. Is it possible to extract specific power bi visual to the master excel template using macro coding?
@mjosic5 жыл бұрын
Nice touch, Avi! How about using Python/R to export data from Power Query? Or use Copy Table in the data model?
@PowerBIPro5 жыл бұрын
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.
@mjosic5 жыл бұрын
@@PowerBIPro Like doing ETL in PowerQuery and them exporting the results to csv via Python script (3 lines of code).
@OlivierTravers5 жыл бұрын
@@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.
@eduardomass4 жыл бұрын
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!
@sivakoteswararao26982 жыл бұрын
How can we set property to run power bi report in excel instead of html format.
@koteshsai95704 жыл бұрын
Hi, Is end user need PowerBi Pro license to export the data ?
@zachgould86443 жыл бұрын
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??
@drguets5 жыл бұрын
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?
@jonarthur5903 жыл бұрын
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.
@KLMCats5 жыл бұрын
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.
@jimmyhumania3 жыл бұрын
good
@mansikasera11533 жыл бұрын
Please let me konw how to export power bi report charts and graphs in excel sheet
@ValesAndTales5 жыл бұрын
Yes
@varunatyam16692 жыл бұрын
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
@AJM21834 жыл бұрын
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...
@tm25352 жыл бұрын
When would you want to download from Power BI to Excel? Why not straight from your database to Excel?
@ahmedel-kholy85614 жыл бұрын
I did not understand the second method, how can i export data from the powerbi.com ?
@rksudhuman5 жыл бұрын
Export option not available in Current version BI embedded :(
@kapudamodhar12523 жыл бұрын
how to export data with out sampling
@adrianapazmino4868 Жыл бұрын
For number 3 how do you open the chart ? Help please