Skip to main content
TrustRadius
Power BI For Office 365 (discontinued)

Power BI For Office 365 (discontinued)

Overview

What is Power BI For Office 365 (discontinued)?

Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.

Read more

Learn from top reviewers

Microsoft cloud based amazing Reporting tool for

Rating: 8 out of 10
November 9, 2021
IncentivizedVetted ReviewVerified User
Power BI is being used as a primary reporting tool across whole organization. It provides attractive GUI compare to other existing tools such as Qlikview and Qliksense. Also i...
Continue reading
Shiv Shrotriya
Analyst - Information Technology
datawarehousing/BI developer
Varian Medical system
Power BI For Office 365 (discontinued)3 years of experience

Excellent program for manipulation and presentation of statistical data.

Rating: 9 out of 10
July 17, 2019
IncentivizedVetted ReviewVerified User
The Microsoft Power BI has been used within the company for a number of years. It is most commonly used in the financial sector of the company and has been delivering excellen...
Continue reading
Denis Pereira
Technician - Information Technology
Programmer Analyst
Alcoa Aluminiun S/A
Power BI For Office 365 (discontinued)1 year of experience

Powerful, easy to use, no-nonsense visualization

Rating: 9 out of 10
January 15, 2019
IncentivizedVetted ReviewVerified User
Power BI is being used primarily by our donor relations team to create visual dashboards of giving profiles, linked with other data sources. This helps us to easily spot trend...
Continue reading
Jeremiah Miller
Director - Information Technology
Associate Director IT Infrastructure
Mennonite Central Committee
Power BI For Office 365 (discontinued)2 years of experience

Power BI Review

Rating: 8 out of 10
June 6, 2016
IncentivizedVetted ReviewVerified User
It is used for pilot projects to asses the benefits of use.
Continue reading
Richard Lorenz
Analyst - Information Technology
Manager of Compliance and Business Performance
Computershare Australia
Power BI For Office 365 (discontinued)1 year of experience

Power BI to reduce BS!

Rating: 7 out of 10
June 1, 2016
IncentivizedVetted ReviewVerified User
I've supported Power BI for companies within the job recruiting area. We implemented the software for staff or more importantly the recruiters to upload data such as health ca...
Continue reading
Daniel J. Lewis
Consultant - Information Technology
System Administrator
vdiscovery
Power BI For Office 365 (discontinued)2 years of experience
Log in with LinkedIn to see content from your network

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing
Power BI For Office 365 (discontinued)

Power BI For Office 365 (discontinued)

N/A
Unavailable

What is Power BI For Office 365 (discontinued)?

Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

3 people also want pricing

Alternatives Pricing

Spotfire

Spotfire

$0.99
Per Hour (Starting)
What is Spotfire?

Spotfire, formerly known as TIBCO Spotfire, is a visual data science platform that combines visual analytics, data science, and data wrangling, so users can analyze data at-rest and at-scale to solve complex industry-specific problems.

Qlik Sense

Qlik Sense

$20
per month per user (10 user minimum)
What is Qlik Sense?

Qlik Sense® is a self-service BI platform for data discovery and visualization. It supports a full range of analytics use cases—data governance, pixel-perfect reporting, and collaboration. Its Associative Engine indexes and connects relationships between data points for creating actionable insights.

Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

9
Avg 8.1

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

9.5
Avg 8.0

Report Output and Scheduling

Ability to schedule and manager report output.

9.5
Avg 8.3

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.

10
Avg 7.9

Access Control and Security

Access control means being able to determine who has access to which data.

9.8
Avg 8.5

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

9.5
Avg 7.8

Application Program Interfaces (APIs) / Embedding

APIs are a set of routines, protocols, and tools for used for embedding one application in another

7.8
Avg 7.7
Return to navigation

Product Details

What is Power BI For Office 365 (discontinued)?

Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.

Power BI For Office 365 (discontinued) Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.

Reviewers rate Report Formatting Templates and Integration with R or other statistical packages and Report sharing and collaboration highest, with a score of 10.

The most common users of Power BI For Office 365 (discontinued) are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 15)

PowerBI.Com - Quick Review

Rating: 9 out of 10
Incentivized
February 19, 2016
AF
Andrew Failor
Data Analytics Consultant
Peters & Associates (Information Technology and Services, 51-200 employees)
Vetted Review
Verified User
Power BI For Office 365 (discontinued)
1 year of experience
View profile
Use Cases and Deployment Scope
This differs from company to company. I have implemented solutions for a single line of business within a company and across all lines within a company. Typically during a deployment, we will develop and release content for a single business line and then move to others. Power BI specifically will display the data you have prepared in the background. It can also be used, by power users / analysts, to explore their own data and to make their own analysis without having to go through IT once a solid data model is in place.
Pros
  • Easily create graphs and visualizations.
  • Distributing dashboards & content packs
  • Finding inconsistencies in data.
Cons
  • If a data source is deployed directly to PowerBI.com without using Power BI desktop, you will not have the ability to troubleshoot connectivity issues which often arise during Metadata and other changes to the model.
  • Not for typical static reporting.
  • No row based security within Power BI itself.
Likelihood to Recommend
It is appropriate for creating graphs and visualizations. These can be created & then deployed or a data model can be deployed and power users can create their own graphs and visualizations.

PowerBI for your dashboard and reporting needs.

Rating: 8 out of 10
Incentivized
December 14, 2018
Verified User
Manager in Information Technology
Computer Hardware Company, 11-50 employees
Vetted Review
Verified User
Power BI For Office 365 (discontinued)
2 years of experience
Use Cases and Deployment Scope
PowerBI is used within our organisation to display various data and metrics in a visual way, but also allows exporting where required to allow users to interact with the data directly in Excel. It is used by all staff at our organisation. For some it is a simple snapshot view of some data to show where we as a company are right now, for others they use it to drill into sales or product data to give them a quick way to see this data without having to use the clunky reports/interface of our ERP system. The product has allowed us to move from just Excel-based reports to dashboards that show visually what is happening. It also provides the option of simple controls to slice and filter the data to requirements. It is simple to use and create visualisations where previously we had to use a separate system for that.
Pros
  • Easy to make visual dashboards from SQL queries. Previously we had to use a third party application that had to run on a web server that was so complex to setup and run. PowerBI removes all that.
  • Ability to control who/which group has access to each dashboard or report. Ties in well with the rest of the Office 365 ecosystem.
  • Has many connectors to allow pulling data from various systems, both onsite (via gateway) or external (via APIs), and join the data to create a report/dashboard.
  • Ability to show data but also export the data, if permitted.
  • Easy to show PowerBI dashboards on SharePoint or on other websites via embedded code.
Cons
  • Once a report uses a Pro feature, it needs a Pro license, but a lot of these are just basic features and the users are just viewing and not using any of the advanced features. It would be nice to have a Pro / Viewing license and Pro / Interacting license.
  • Limited amount of refreshes per 24 hours period. 5 refreshes as of Dec 2018.
  • The emailing of reports is there but kind of basic. It will do a screen grab of a report, which doesn't turn out very well.
Likelihood to Recommend
If you want to create a visual dashboard or report that utilises various data sources then PowerBI can do this. It is great in that it takes your on-premises data and stores it on Microsoft servers where it can interact with it faster, reducing load on your own servers, while being efficient in what it transfers out.

We have found it not well suited if you wanted to publish a simple report to many staff as they may all need a Pro license which can get expensive. Even if embedding the report onto a shared platform like SharePoint, it will not display if the users doesn't have a PowerBI Pro license.

Excellent program for manipulation and presentation of statistical data.

Rating: 9 out of 10
Incentivized
July 17, 2019
DP
Denis Pereira
Programmer Analyst
Alcoa Aluminiun S/A (Mining & Metals, 10,001+ employees)
Vetted Review
Verified User
Power BI For Office 365 (discontinued)
1 year of experience
Use Cases and Deployment Scope
The Microsoft Power BI has been used within the company for a number of years. It is most commonly used in the financial sector of the company and has been delivering excellent results and handling facilities for managers. It shows in detail each value, graphic and is very easy to understand. In the presentations, the software is entering the place of excel.
Pros
  • Helps to create machine learning models and find cognitive insights
  • Connects to virtually all existing data sources (Google Analytics, SalesForce, and others)
  • High performance and high compression ratio
  • Very easy to implement
Cons
  • Need to have more advanced knowledge in excel
  • Some elements are limited
Likelihood to Recommend
The Microsoft Power BI is used to hold global meetings in the financial industry. It has good dynamics and makes it easier to understand values ​​and graphics. However, to use it, you need to have a little knowledge in Microsoft Office Excel, as you may have difficulty using it otherwise. The cost of the license is low, I believe it compensates the investor.

Power BI for Office 365 - A compelling data analytics platform for personal and team use

Rating: 8 out of 10
May 21, 2014
KR
Ken Raetz
Manager, DW/BI Services
LBMC Technologies, LLC (Information Technology and Services, 11-50 employees)
Vetted Review
Verified User
Power BI For Office 365 (discontinued)
1 year of experience
Use Cases and Deployment Scope

We are a Microsoft partner, with my line of business focusing on creating data-driven solutions for our customers, ranging from IT-sponsored enterprise data warehouse initiatives to small team and personal business analytics solutions. My consulting team uses Power BI for primarily two purposes: 1) to create pilot/proof-of-concept solutions for our customers to help launch them on their BI journey; 2) to perform data analytics on larger enterprise data-driven initiatives. The agility of the Excel-based solution, combined with the power of the in-memory PowerPivot data engine, more than meets our need for the these 2 purposes. Our customers appreciate it because it allows them to remain in their very familiar Excel environment.

We are working with mostly finance/accounting departments, and in some cases, business analysts (or "power users") within the business community (sales, marketing, etc.). We are solving finance challenges like Accounts Receivable collections, along with operational challenges such as monitoring year-over-year sales metrics and comparing them to budgets that come from two data locations. In addition, we're solving painful "process issues" like trying to import multiple files into a single data set. We are literally reducing process time from days to minutes!

Pros
  • Provides flexible and powerful analytics on large datasets. PowerPivot, the in-memory database engine, can handle 100's of millions of rows of data, giving 1-2 second response time for aggregate data analysis.
  • Provides an adaptable environment to perform analytics. When combining data together in PowerPivot, you have the ability to create Excel tables, combine them with database queries, and then join that with data coming from a web-service provider.
  • Powerful web-based deployment capabilities. SharePoint technologies have been a part of the Microsoft BI solution stack for some time. Office 365 provides a powerful way to deploy the Power BI analytics to a wider audience in a secure way, allowing for flexible access from most any device, whether phone, tablet, or computer.
  • Power Query, one of the components of Power BI, is one of my favorite parts of the solution. Basically, you have at your disposal an end-user "ETL" (Extract, Transform, Load) tool, all within Excel. We've reduced multi-step, manual processes to single-click, automatic application of business rules to collect and transform data into a usable format. No need for VLOOKUP any longer with this capability.
Cons
  • Licensing: Currently, Microsoft has a fixed pricing model for Office 365 users, regardless of role/function of the user. Most organizations have a small number of "power users" that create usable content and many more "consumers" that simply view/run reports created by power users. Microsoft does not differentiate between these users, and thus the pricing limits organizations from large deployments of the software.
  • Version incompatibility: Excel 2010 and 2013 workbooks are compatible with each other. However, workbooks created in 2010 that include PowerPivot databases must be upgraded to 2013 format to run in 2013. Subsequently, you cannot open these upgraded PowerPivot workbooks in 2010. This requires ALL users to be on the same version.
  • Visualization: Excel charting with PowerPivot workbooks is adequate for many users. Power View also contains a number of GREAT visualizations, including animated bubble charts and a very flexible dashboard/report design canvas. However, compared to some of the other self-service BI solutions, it is still limited in its visualization capabilities.
Likelihood to Recommend

Well-suited: In small-to-medium size businesses (SMB), Power BI is a wonderful solution. The speed to design and deploy a highly valuable solution makes it a fantastic selection for these businesses. Also, individual or small teams, even in large corporations, can benefit from it. Finally, accounting, finance, and business analysts are the "sweet-spot audience" for Power BI. Also, Power BI is great for designing prototypes or mockups of future enterprise capabilities.

Less Appropriate: Information Technology team developing an enterprise analytics solution. Power BI is not intended to be an enterprise solution. Power BI is fully capable of handling millions of rows of data for analysis. However, in more complex analytical scenarios, where complex rules are incorporated into the data model over VERY LARGE sets of data (in particular, dimensional/structural data), the PowerPivot solution is not as strong. It is generally recommended that you upgrade to SQL Server Analysis Services for these scenarios.

BI by Microsoft

Rating: 8 out of 10
Incentivized
February 08, 2018
Verified User
Technician in Information Technology
Gambling & Casinos Company, 51-200 employees
Vetted Review
Verified User
Power BI For Office 365 (discontinued)
2 years of experience
Use Cases and Deployment Scope
Power BI for office 365 (now simply become {Power BI}, is a unique and general platform for managing business intelligence through Microsoft tools. The platform is then subdivided into services rather than desktop or mobile. Thanks to this, in my experience, it was possible to create customized and performing BI tools.
Pros
  • perfectly integrated with microsoft tools
  • objects can be easily shared in mobile environments
  • attractive dashboards
Cons
  • in the standard version it is not possible to do analysis by excel
  • the Pro version is required for sharing jobs
  • only a few data sources allow real time connections
Likelihood to Recommend
If you want to get closer to the world of BI and work in a Microsoft environment you can definitely evaluate the tools of Power BI and see if they are right for you. I recommend you buy the PRO version otherwise you can not use the most useful features of BI. The cost is moreover certainly less than many other competitors.
Return to navigation