Will Power BI desktop replace Power View, Query and Maps

[BM]

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?

[Greg_Deckler]

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.

[BM]

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

[Greg_Deckler]

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.

[leonardmurphy · 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.