Power BI

What is Power BI?

Power BI is a cloud-based service that works with Excel to provide a complete self-service business intelligence (BI) solution. With both Excel and Power BI for Office 365, you can give everyone in your organization a powerful new way to work with data. In Excel, you can now discover, analyse, and visualize data like never before to find valuable business insights.

Power BI sites on Office 365

With Power BI for Office 365 you can easily deploy a cloud-based BI environment for users to share insights, collaborate and access reports, from anywhere on any device while asking questions in natural language to get live interactive answers through data visualizations.

The Power BI sites app is available when you register for Power BI for Office 365. You can apply it to a new or an existing site in SharePoint Online Enterprise. Add the Power BI sites app to your Power BI site.

Since Power BI is a cloud-based service, you will need Excel 2013 to create reports and models that can be consumed and refreshed with Power BI. Office 365 ProPlus or Microsoft Office Professional Plus 2013 include Excel 2013 that will give you access to Power Query, Power Pivot, Power View and Power Map to discover, analyze and visualize data. With Power BI you will be able to consume these reports created in Excel through your browser or mobile apps and to use cloud-based features such as natural language Q&A, data refresh, data catalog and Power BI sites.

The Power BI trial includes Office 365 ProPlus on top of the Power BI service so you can try the full experience end to end. Contact us for a free 30 day Power BI trial!

Features included in Power BI for Office 365

Power BI for Office 365 includes the following cloud-based capabilities:

  • Quickly create collaborative BI sites – enable anyone to quickly create a collaborative BI site to share workbooks containing data and insights.
  • Keep reports up to date with scheduled data refresh – reports that have been saved to the cloud can now connect back to on-premises data sources to refresh the data and stay up to date.
  • Manage data queries for the team – share not only workbooks but also the data queries created in Power Query for Excel. Team members can now build and manage data queries for others to use when creating their own reports.
  • Maintain a Data Catalog of searchable data – IT departments can now use the Data Catalog feature to make it easier for everyone to find and connect to corporate data by searching for it from within Excel.
  • Ask questions of your data in natural language – with the Q&A features people can type questions they have of the data in natural language and the system will interpret the question and present answers in the form of interactive visualizations.
  • Stay connected with mobile access to your reports – stay connected from anywhere with new HTML5 support and the Power BI mobile app.

Contact us now for a free 30 day trial of Power BI for Office 365. This trial would also include Office 365 ProPlus, allowing you to create reports with Excel 2013 to consume with Power BI.

Add-on for E3/E4 subscribers Standalone
£7.99 user/monthannual commitment £12.99 user/monthannual commitment
Power BI for Office 365
BI Sites
Available Dot Available Dot
Scheduled Data Refresh
Available Dot Available Dot
Enterprise Data Search
Available Dot Available Dot
Data Stewardship
Available Dot Available Dot
Mobile BI Service
Available Dot Available Dot
Natural Language Query
Available Dot Available Dot
SharePoint Online Plan 2
Available Dot
Contact us for a free trial

Upcoming Features

Power BI Power BI Pro
FREE $9.99 user/month
Data Capacity Limit
1 GB/user 10 GB/user
Create, view and share personal dashboards and reports
Available Dot Available Dot
Power BI Designer for content authoring
Available Dot Available Dot
Explore data with natural language
Available Dot Available Dot
Power BI mobile apps for iOS and Windows
Available Dot Available Dot
Content packs for services like Dynamics, Salesforce, and SendGrid
Available Dot Available Dot
Import data and reports from Excel files
Available Dot Available Dot
Scheduled Data Refresh
Daily Hourly
Support for Streaming Data
10K rows/hour 1M rows/hour
Live interactive connectivity to data sources
Available Dot
Data Management Gateway
Available Dot
Share refreshable team dashboards and reports
Available Dot
Create and publish customized content packs
Available Dot
Use of Active Directory groups for sharing & managing access control
Available Dot
Shared data queries through the Data Catalog
Available Dot
Contact us to try the preview