Using Analyze in Excel from Power BI [Excel to Power BI Series - Ep. 5]

In this video, Jonathon continues his series on how to bridge your Excel skills into Power BI by showing how to take a Power BI dataset and export it into Excel using a feature called Analyze in Excel. Watch as he navigates through the Power BI Service to download an Excel file that is connected to a Power BI dataset and works to build a PivotTable, PivotChart, and Slicer from that data.
If you would like to see past videos of Jonathon’s RUclips series, you can access them here: • 💡 What is the Power Qu...
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Jonathon30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RUclips: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks #JonathonSilva
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

[@RehanShaikh-ip9hh]

Wonderful... We can validate the data in Excel itself...great thanks for the sharing...

[@PragmaticWorks]

Glad you enjoyed!

[@reubensiwela3448]

Thank you, i love your energy and how you explain

[@PragmaticWorks]

I appreciate that! Thanks for watching!

[@saloriasaxon7323]

You guys are the greatest here and love the videos very much!

[@PragmaticWorks]

Glad to hear that!

[@zohrashikhiyeva3167]

VERY USEFULL ! THANKS FOR SHARİNG!

[@PragmaticWorks]

Glad you enjoyed!

[@AllenRose]

Hi Jonathon, Is this "Analyze in Excel" feature available in "PowerBI Desktop" as well? great work.

[@sylau1516]

Thanks. Very clear explanation. One question - how to fresh the data or reconnect back to the same dataset? Thanks.

[@Jonathon_Silva]

The data will be refreshed inside the model at Power BI service. This can be done manually, or with a scheduled refresh.

[@no_name5002]

Great stuff. If I send the excel file (already connected to PowerBI) to a colleague, Would that colleague be able to refresh him/herself?

[@Jonathon_Silva]

That colleague would need to have access to the Power BI dataset, either in the workspace or if it was shared with them. They would then be able to refresh the Excel workbook and PivotTables, but not the actual full dataset that was published in Power BI - which would have to be done in the Power BI service.

[@evelic]

What about if this gets very slow when using it in excel? Currently dealing with that issue using a model of around 600,000 rows data set and 4 demension tables filtering it.

[@evelic]

Probably you need to request more capacity for your worskapce with your IT team.

[@AlTincu]

Thank you. Is it possible to connect to a report instead of a dataset? I use a shared dataset(created by others) and I add measures, then pubblish the report. When i try the Analyze in excel, i don't have my measures, but only the ones existing already in the dataset.

[@vishalmalpure6008]

Hi, i am also looking for the same solution. Kindly let me know if you were able to got through on this .
Will be really helpful !
Thanks

[@Anurita_1004]

Can I save this excel sheet on my desktop for further use.

[@Jonathon_Silva]

Absolutely, you can save this sheet just like you would with any other excel file!

[@Anurita_1004]

@@Jonathon_Silva okay, thanks for letting know.

[@divyagandala6929]

I have a pro license, and have downloaded "Analyze in Excel", but still i can see it is disabled

[@AllenRose]

From where have you downloaded the "Analyze in Excel"? Thanks!