cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BM Frequent Visitor
Frequent Visitor

Will Power BI desktop replace Power View, Query and Maps

I have Microsoft Office 10 so cannot use some of the Power BI Tools.  I can however use Power BI Desktop.  Do you think there will be a need to use Power View, Query and Maps in the future or will Power BI Desktop do what these tools do?

1 ACCEPTED SOLUTION

Accepted Solutions
leonardmurphy Established Member
Established Member

Re: Will Power BI desktop replace Power View, Query and Maps

Power BI Desktop is designed for exactly your situation: people who don't have the latest version of Excel but want to use the latest features. If anything the features in Power BI Desktop get updated more rapidly than the features in Excel.

 

The main difference between the Power BI Desktop and Excel is that the Power BI Desktop is focused on Power BI. It generates pbix files and works with powerbi.com. There's no 'export to Excel' (right now at least). By contrast, the Power tools in Excel work very well with Excel (and also work with Power BI).

 

If your intent is to get started with powerbi.com, you can work with the Power BI Desktop exclusively and never have to switch to using the Excel tools.

 

The one exception: Power Map (3D Maps in Excel 2016) - is exclusive to Excel and the same functionality doesn't exist in Power BI Desktop.

 

Hope this helps.

---
In Wisconsin? Join the Microsoft BI Professionals - Wisconsin group.

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Re: Will Power BI desktop replace Power View, Query and Maps

Excel 2016 still has Power Query, Power View, etc. in it, not really sure where Power Maps is going. What Power BI Tools are you having issues with? I am running Windows 10 as well.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

BM Frequent Visitor
Frequent Visitor

Re: Will Power BI desktop replace Power View, Query and Maps

I have Microsoft Office 2010.  So the version of Excel I have is 2010.  This means I do not have Power Query, Power View etc and am wondering if it matters if I can use Power BI Desktop

leonardmurphy Established Member
Established Member

Re: Will Power BI desktop replace Power View, Query and Maps

Power BI Desktop is designed for exactly your situation: people who don't have the latest version of Excel but want to use the latest features. If anything the features in Power BI Desktop get updated more rapidly than the features in Excel.

 

The main difference between the Power BI Desktop and Excel is that the Power BI Desktop is focused on Power BI. It generates pbix files and works with powerbi.com. There's no 'export to Excel' (right now at least). By contrast, the Power tools in Excel work very well with Excel (and also work with Power BI).

 

If your intent is to get started with powerbi.com, you can work with the Power BI Desktop exclusively and never have to switch to using the Excel tools.

 

The one exception: Power Map (3D Maps in Excel 2016) - is exclusive to Excel and the same functionality doesn't exist in Power BI Desktop.

 

Hope this helps.

---
In Wisconsin? Join the Microsoft BI Professionals - Wisconsin group.

View solution in original post

Super User IV
Super User IV

Re: Will Power BI desktop replace Power View, Query and Maps

I believe that all of those tools are free add-ins for Excel 2010, at least I know Power Query is:

 

https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=6b90804c-094a-4e61-b109...

 

 

Excel 2010 with SA is supported.

 

OK, I use Power Query, Power View and such in Excel on my Windows 10 device all the time so I was curious what I was missing. Sounds like your issue is more of an issue with Office version, not OS version.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors