Microsoft Power Query for Excel seamlessly connects to SAP BusinessObjects BI Universes enabling users to access and analyze data across the enterprise and share their data and insights through Power BI.
This connectivity drives a single version of truth, instant productivity, and optimized business performance for your organization.
Download Microsoft Power Query Preview for Excel
Preview contains SAP BusinessObjects BI Universe connectivity.
Microsoft Power Query Preview for Excel, providing SAP BusinessObjects BI Universe connectivity, is an add-in that provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users. This preview provides an early look into the upcoming SAP BusinessObjects BI Universe connectivity feature. As with most previews, this feature may appear differently in the final product.
- PowerQuery (32-bit) [en-US].msi
- PowerQuery (64-bit) [en-US].msi
- PowerQuery (32-bit) [fr-FR].msi
- PowerQuery (64-bit) [fr-FR].msi
- PowerQuery (32-bit) [de-DE].msi
- PowerQuery (64-bit) [de-DE].msi
- PowerQuery (32-bit) [es-ES].msi
- PowerQuery (64-bit) [es-ES].msi
- PowerQuery (32-bit) [jp-JP].msi
- PowerQuery (64-bit) [jp-JP].msi
- PowerQuery (32-bit) [pt-BR].msi
- PowerQuery (64-bit) [pt-BR].msi
Supported operating systems
Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Vista
- Windows Vista (requires .NET 3.5SP1)
- Windows Server 2008 (requires .NET 3.5 SP1)
- Windows 7
- Windows 8
- Windows 8.1
The following Office versions are supported:
- Microsoft Office 2010 Professional Plus with Software Assurance
- Microsoft Office 2013 Professional Plus, Office 365 ProPlus or Excel 2013 Standalone
Microsoft Power Query Preview for Excel requires Internet Explorer 9 or greater.
Microsoft Power Query Preview for Excel is available for 32-bit (x86) and 64-bit (x64) platforms, your selection must match architecture of the installed version of Office.
Download the version of the Power Query add-in that matches the architecture (x86 or x64) of your Office installation. Run the MSI installer and follow the setup steps.
Access and analyze your trusted enterprise data
Learn how Microsoft and SAP deliver a combination of trusted enterprise data and familiar market leading tools.
Single version of truth
Deliver the latest, accurate and trusted data from across the enterprise, such as from SAP applications, directly into the hands of users in Microsoft Excel. They no longer need to constantly copy and paste or import data using a manual process leading to inaccuracy. Users can instead focus on leveraging their knowledge to analyze data from within and outside your organization. They can get answers and uncover new insights to better deal with the challenges facing your organization, eliminating costly decisions based on inaccurate data.
Users can continue to work in their familiar Microsoft Excel environment with access to business friendly terms from SAP BusinessObjects BI Universes at their fingertips, allowing for deeper analysis on their own. Using familiar tools enables them to easily integrate data and insights into existing workflows without the need to learn new complex tools and skills. Any uncovered data and insights can be kept up to date with no hassle refreshing from on-premises and the cloud, increasing productivity.
Optimized business performance
Leveraging existing investments from both companies together enables your organization to unlock insights faster and react accordingly. Your organization can identify patterns, cost drivers, and opportunities for savings in an agile, accurate, and visual manner. Specific trends and goals can be measured while having visually attractive and up to date dashboards. Relying on trusted enterprise data reduces costs and increases profitability by allowing faster, better, and timelier decisions. All of this drives broader BI adoption to create an information driven culture across your organization.
Unlocked data and insights
Drive trusted enterprise data and insights from an SAP BusinessObjects BI Universe throughout your organization by sharing and collaborating with Power BI from anywhere. Anyone can create a collaborative BI site to share data and insights relying on the latest data from either on-premises or the cloud using scheduled refreshing. Users no longer have to struggle to think up and answer every single question in advance, instead interactively investigating data when they need it through natural language Q&A. Better yet, they can stay connected with mobile access to data and insights generating a deeper understanding of the business and communicating more effectively from anywhere.