cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BM
New Member

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

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
Greg_Deckler
Super User IV
Super User IV

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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




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

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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors