Pros and Cons of Power BI For Office 365 (discontinued) 2025

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.

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...

Shiv Shrotriya

Analyst - Information Technology

datawarehousing/BI developer

Varian Medical system

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...

Denis Pereira

Technician - Information Technology

Programmer Analyst

Alcoa Aluminiun S/A

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...

Jeremiah Miller

Director - Information Technology

Associate Director IT Infrastructure

Mennonite Central Committee

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.

Richard Lorenz

Analyst - Information Technology

Manager of Compliance and Business Performance

Computershare Australia

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...

Daniel J. Lewis

Consultant - Information Technology

System Administrator

vdiscovery

2 years of experience

Log in with LinkedIn to see content from your network

Return to navigation

Pricing

View all pricing

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

Qlik Sense

$200

per month

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.

SAP Analytics Cloud

$36

per month per user

What is SAP Analytics Cloud?

The SAP Analytics Cloud solution brings together analytics and planning with integration to SAP applications and access to heterogenous data sources. As the analytics and planning solution within SAP Business Technology Platform, SAP Analytics Cloud supports trusted insights and integrated planning…

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.2

Ad-hoc Reporting

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

9.5

Avg 8.0

9
Drill-down analysis
(11) Ratings
Drill down analysis is the ability to get to a further level of detail by going deeper into the hierarchy.
9
Formatting capabilities
(11) Ratings
Ability to format output e.g. conditional formatting, lines, headers, footers.
10
Integration with R or other statistical packages
(6) Ratings
Integration with the open-source R predictive modeling environment.
10
Report sharing and collaboration
(11) Ratings
Report sharing and collaboration is the ability to easily share reports with others.

Report Output and Scheduling

Ability to schedule and manager report output.

9.5

Avg 8.3

10
Publish to Web
(11) Ratings
10
Publish to PDF
(10) Ratings
9
Report Versioning
(6) Ratings
Report versioning is the assignment of version numbers to each version of a report to help in tracking.
9.6
Report Delivery Scheduling
(4) Ratings
Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.
8.7
Delivery to Remote Servers
(3) Ratings
Ability to deliver reports to remote servers

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

10
Pre-built visualization formats (heatmaps, scatter plots etc.)
(10) Ratings
Pre-built visualization formats are canned visualization types that can be selected to visualize different kinds of data.
10
Location Analytics / Geographic Visualization
(11) Ratings
Location analytics is the visualization of geographical or spatial data.
10
Predictive Analytics
(8) Ratings
Predictive Analytics is the ability to build forecasting models based on existing data sets.

Access Control and Security

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

9.8

Avg 8.6

10
Multi-User Support (named login)
(10) Ratings
Named model access means that users have access based on name and password.
9
Role-Based Security Model
(8) Ratings
Role-based access means that access to data is determined by job or position in the corporation.
10
Multiple Access Permission Levels (Create, Read, Delete)
(9) Ratings
Multiple access permission levels means that different levels of users have different rights.
10
Single Sign-On (SSO)
(5) Ratings
Allows users to use one set of login credentials to access multiple applications

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

9
REST API
(2) Ratings
REST is an architecture style for designing networked applications
8
Javascript API
(2) Ratings
A Javascript API is a type of API
8
iFrames
(1) Ratings
An iFrame is an HTML document embedded inside another HTML document on a website
8
Java API
(1) Ratings
A Java application programming interface (API) is a list of all classes that are part of the Java development kit (JDK)
7
Themeable User Interface (UI)
(2) Ratings
A themeable user interface means that a specific visual them can be applied to it
7
Customizable Platform (Open Source)
(2) Ratings
A customizable, open source API Gateway is a fast and scalable type of API

Return to navigation

Product Details

About
Tech Details
FAQs

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 Systems	Unspecified
Mobile Application	No

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 Enterprises (1,001+ employees).

Return to navigation

Comparisons

View all alternatives

Compare with

Reviews From Top Reviewers

View all reviews

(1-5 of 15)

Sort By *

Microsoft cloud based amazing Reporting tool for

Rating: 8 out of 10

Incentivized

November 09, 2021

SS

Shiv Shrotriya

datawarehousing/BI developer

Varian Medical system (Hospital & Health Care, 10,001+ employees)

Vetted Review

Verified User

3 years of experience

Pros

Attractive GUI compare to other tools
Development is easy
very low maintenance
Easy connectivity with other Microsoft platforms

Cons

Connectivity with more sources such as SAP
functionality to maintain history (snapshots)

Powerful, easy to use, no-nonsense visualization

Rating: 9 out of 10

Incentivized

January 15, 2019

JM

Jeremiah Miller

Associate Director IT Infrastructure

Mennonite Central Committee (Non-Profit Organization Management, 1001-5000 employees)

Vetted Review

Verified User

2 years of experience

View profile

Pros

Data visualization - it's easy for users to visualize data using many built-in controls.
Distributing reports and dashboards and delivering in real time on the web. Reports can be updated in real-time and display updated results automatically to decision makers.
Pulling data from diverse data sources. Data can be pulled from a wide variety of databases, even flat-file text.

Cons

Power BI is not a classic reporting tool, so it can't easily be used for financial reports.
It can be quite expensive. Even those just viewing reports need a paid license to consume shared content.
Error logging is very unhelpful. When something goes wrong with a dataset, it can be very difficult to see where the problem is.

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

1 year of experience

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

Power BI Review

Rating: 8 out of 10

Incentivized

June 06, 2016

RL

Richard Lorenz

Manager of Compliance and Business Performance

Computershare Australia (Financial Services, 10,001+ employees)

Vetted Review

Verified User

1 year of experience

View profile

Pros

Beautiful visuals
Ease of use
Powerful data manipulation language

Cons

I'd like to be able to use visuals based on different data sets in the same page.
The visuals are limited - I'd like to see a ribbon plot for example.
Would like to be able to use different data representations on the same visual. There's currently an ability to put lines on histograms but no ability to, for example, add points to a histogram or line plot. I understand some of these may be in development but you will never be able to create visuals for each possible combination. You need a way of combining two visuals into one - e.g. line and points.
DAX is very powerful but a bit complicated for some users. I think you need to make some of the functionality that's available in DAX exposed at the UI level.
The R visual gives the flexibility to plot a lot of stuff but it is limited by only being able to plot what's passed in the dataset.
You need a text entry box that you can filter datasets by.

Power BI to reduce BS!

Rating: 7 out of 10

Incentivized

June 01, 2016

DJ

Daniel J. Lewis

System Administrator

vdiscovery (Information Technology and Services, 51-200 employees)

Vetted Review

Verified User

2 years of experience

View profile

Pros

The dashboard is super easy to use. The GUI is flexible and updates as needed
Customization was key for individuals and presentation purposes.
Integration with Office 365 is another plus. The licensing made sense when pitching the proposal when a client is already running Office 365.

Cons

Well in general Microsoft support needs CPR.
There are bugs such as some items you'd think were allowed on the dashboard are not options however from reading they are continuing to improve these concerns/features.
Implementation can be finicky depending on how the current environment is configured.

Return to navigation

Power BI For Office 365 (discontinued)

Qlik Sense

SAP Analytics Cloud

Microsoft Power Automate

S&P Capital IQ

Grist

IBM SPSS Statistics

GraphPad Prism

JMP

Camunda

Pega Platform

Flexmonster Pivot Table & Charts Component

Excel4apps

Cons

Cons

Cons

Cons

Cons