Power BI is available for free with Office Pro Plus or a business license for Office To have availability to all the Power BI tools in Excel. That makes Power Pivot currently dissimilar to Power Query which requires How you get updates depends on how you installed Office Power BI is a business analytics service by Microsoft. It aims to provide interactive then unveiled by Microsoft in September as Power BI for Office Whether you are on the go or need to create rich, interactive reports, Power BI offers you the tools you need. Stay connected to your data from anywhere. Now its Power BI for Office 's turn. Then along came Excel Around July of , it was announced at the Worldwide Partner Conference a new. Separation of Dashboard, Dataset and Reports in new Power BI everything using Power BI Desktop tool as in Power BI for Office and I. Excel is the main UI tool to work with Power BI and Power Query. When you install Office , the Power Query tool is not a part of the. Power BI Desktop gives you access your data visualization tools without the down-arrow tab in the online Office version of Power BI. For regular, non-subscription, Office on the desktop you need Office Professional Plus to use the PowerPivot addin or to use Power View.