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
Recent Reviews

BI by Microsoft

8 out of 10
February 08, 2018
Incentivized
Power BI for office 365 (now simply become {Power BI}, is a unique and general platform for managing business intelligence through …
Continue reading

Find the POWER

7 out of 10
February 16, 2016
Incentivized
We gather all of our sales and digital marketing data into BI and create reports for management that really show our effectiveness in the …
Continue reading

Power BI worth a look? YES!

10 out of 10
March 26, 2015
I'm a Senior BI Consultant, and have been developing reports with various tools for many years. I started with Crystal Reports, then …
Continue reading

Just BI

9 out of 10
November 04, 2014
My organization is not using Office 365 yet. I did the research myself and have a given demo to my organization. We may purchase and use it.
Continue reading
Read all reviews

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

Popular Features

View all 28 features
  • Report sharing and collaboration (11)
    10.0
    100%
  • Drill-down analysis (11)
    9.0
    90%
  • Formatting capabilities (11)
    9.0
    90%
  • Customizable dashboards (11)
    8.0
    80%
Return to navigation

Pricing

View all pricing
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?

2 people also want pricing

Alternatives Pricing

What is Spotfire?

Spotfire® is a data visualization platform that utilizes predictive analytics. In addition to data viz, it includes data wrangling capabilities, predictive analytics, location analytics, and real-time streaming analytics. Spotfire® is a business unit of Cloud Software Group, formerly known as…

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

Report Output and Scheduling

Ability to schedule and manager report output.

9.5
Avg 8.4

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 8.1

Access Control and Security

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

9.8
Avg 8.6

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

9.5
Avg 8.0

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

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(214)

Attribute Ratings

Reviews

(1-4 of 4)
Companies can't remove reviews or game the system. Here's why
Shiv Shrotriya | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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 it enables end users to build their own reports if data model is ready as development is very easy (drag and drop approach).
  • Attractive GUI compare to other tools
  • Development is easy
  • very low maintenance
  • Easy connectivity with other Microsoft platforms
  • Connectivity with more sources such as SAP
  • functionality to maintain history (snapshots)
If you have perfect data model ready and ETL team to build the data as per business need then its very amazing tool with eye catching GUI and development will be very quick.
but if you need to build snapshot kind of logic and need to maintain the history then this tool will not work.
BI Platform
N/A
N/A
Supported Data Sources
N/A
N/A
BI Standard Reporting (3)
90%
9.0
Pixel Perfect reports
90%
9.0
Customizable dashboards
80%
8.0
Report Formatting Templates
100%
10.0
Ad-hoc Reporting (4)
95%
9.5
Drill-down analysis
90%
9.0
Formatting capabilities
90%
9.0
Integration with R or other statistical packages
100%
10.0
Report sharing and collaboration
100%
10.0
Report Output and Scheduling (4)
72.5%
7.3
Publish to Web
100%
10.0
Publish to PDF
100%
10.0
Report Versioning
90%
9.0
Report Delivery Scheduling
N/A
N/A
Data Discovery and Visualization (3)
100%
10.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
100%
10.0
Location Analytics / Geographic Visualization
100%
10.0
Predictive Analytics
100%
10.0
Access Control and Security (4)
97.5%
9.8
Multi-User Support (named login)
100%
10.0
Role-Based Security Model
90%
9.0
Multiple Access Permission Levels (Create, Read, Delete)
100%
10.0
Single Sign-On (SSO)
100%
10.0
Mobile Capabilities (3)
96.66666666666666%
9.7
Responsive Design for Web Access
100%
10.0
Mobile Application
90%
9.0
Dashboard / Report / Visualization Interactivity on Mobile
100%
10.0
Application Program Interfaces (APIs) / Embedding (6)
78.33333333333333%
7.8
REST API
90%
9.0
Javascript API
80%
8.0
iFrames
80%
8.0
Java API
80%
8.0
Themeable User Interface (UI)
70%
7.0
Customizable Platform (Open Source)
70%
7.0
  • Customer Satisfaction with dashboards
  • Insights of business
  • low cost compare to other tools such as Tableau
  • very low maintenance
  • Cost effective compare to other tools(QlikView, Tableau CRM), license is much cheaper than other BI tools.
  • Easy development and preferred by customers.
  • offer attractive representation of data, power BI gives almost 250 different kinds of charts and graphs to represent the data.
  • maintenance is very low as cloud based solution.
  • With DAX, you can perform complex calculations in dashboards.


We are satisfied with the functionality and capabilities of Power BI. Product is cost effective and full-fill the reporting requirements of the organization. You can perform most of the report level complex analysis with the help of DAX which makes Power BI very powerful analytic tool. Power BI for Office 365 has gone away and Power BI is the next evolution of it. Power BI comes with your Office 365 E5 subscription or you can purchase licensing for it separately.
as of now there is strong community for Power BI, you can get solution for most of your problems from there. Also you can send your error to Microsoft as well. After every 15 days they release updates to overcome all the issues of defects.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We are using Power BI to create better visual representations for both internal use as well as customer facing analysis. It's not adopted across the entire organization yet but we are in the process of doing so.
  • Ease of data import
  • Easy to learn the basic operation of the software
  • Like many Microsoft products, you can get by with a small understanding of the product, but to truly realize the entire potential does take a while to learn.
  • Hooking up SQL databases to the cloud version is a more complex than just querying right into the database from the desktop version.
We frequently use the mapping feature to overlay areas in which we have strong operations and areas in which our customers have needs to quickly visualize opportunities to new and existing clients. We are also beginning to develop internal scorecards with it. One downside is we haven't discovered a way to automate a data refresh from the SQL connection, so you have to remember to refresh the data (which can take a little while depending on how much data your looking for) every time.
BI Platform
N/A
N/A
Supported Data Sources
N/A
N/A
BI Standard Reporting (3)
63.33333333333333%
6.3
Pixel Perfect reports
70%
7.0
Customizable dashboards
50%
5.0
Report Formatting Templates
70%
7.0
Ad-hoc Reporting (3)
70%
7.0
Drill-down analysis
70%
7.0
Formatting capabilities
70%
7.0
Report sharing and collaboration
70%
7.0
Report Output and Scheduling (3)
56.66666666666667%
5.7
Publish to Web
50%
5.0
Publish to PDF
70%
7.0
Report Versioning
50%
5.0
Data Discovery and Visualization (3)
66.66666666666667%
6.7
Pre-built visualization formats (heatmaps, scatter plots etc.)
70%
7.0
Location Analytics / Geographic Visualization
90%
9.0
Predictive Analytics
40%
4.0
Access Control and Security (1)
70%
7.0
Multi-User Support (named login)
70%
7.0
Mobile Capabilities (3)
66.66666666666667%
6.7
Responsive Design for Web Access
50%
5.0
Mobile Application
80%
8.0
Dashboard / Report / Visualization Interactivity on Mobile
70%
7.0
Application Program Interfaces (APIs) / Embedding
N/A
N/A
  • It's allowed us to better visualize large amounts of data.
  • It's an easy way to tie into an existing SQL database for users that don't know SQL.
Much less expensive, particularly if your already an Office 365 customer.
Ryan Elfline | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I am a single person putting together reports/dashboards to send out for others to interpret. The biggest problem right now is there is no direct connection to Microsoft Dynamics AX 2012.
  • The visuals are excellent
  • The interaction of data between graphs and charts
  • The way the program saves how data sheets are manipulated.
  • Connection to Microsoft Dynamics AX 2012
  • Dashboards need to automatically update when I upload a report
  • Increase speed
It's well suited for analytics for sales, utilization, downtime, and spending.
BI Platform
N/A
N/A
Supported Data Sources
N/A
N/A
BI Standard Reporting (3)
80%
8.0
Pixel Perfect reports
80%
8.0
Customizable dashboards
90%
9.0
Report Formatting Templates
70%
7.0
Ad-hoc Reporting (4)
55%
5.5
Drill-down analysis
90%
9.0
Formatting capabilities
70%
7.0
Integration with R or other statistical packages
N/A
N/A
Report sharing and collaboration
60%
6.0
Report Output and Scheduling (4)
45%
4.5
Publish to Web
80%
8.0
Publish to PDF
30%
3.0
Report Versioning
70%
7.0
Report Delivery Scheduling
N/A
N/A
Data Discovery and Visualization (3)
53.33333333333333%
5.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
60%
6.0
Location Analytics / Geographic Visualization
50%
5.0
Predictive Analytics
50%
5.0
Access Control and Security (3)
50%
5.0
Multi-User Support (named login)
50%
5.0
Role-Based Security Model
50%
5.0
Multiple Access Permission Levels (Create, Read, Delete)
50%
5.0
Mobile Capabilities (3)
56.66666666666667%
5.7
Responsive Design for Web Access
70%
7.0
Mobile Application
70%
7.0
Dashboard / Report / Visualization Interactivity on Mobile
30%
3.0
Application Program Interfaces (APIs) / Embedding
N/A
N/A
  • We get our money's worth. Would be willing to pay more to get more out of a program.
Ken Raetz | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

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!

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

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.

  • As a Microsoft Partner implementing Business Intelligence solutions, Power BI has removed the barrier for our clients to begin the "BI journey". So often, projects get hung up in that early phase of procuring and installing/configuring expensive hardware and software. Just simply getting started and designing a beginning solution has allowed our clients to see results in 1-2 weeks using their data that might have taken months to achieve otherwise.
  • One significant ROI example is process improvement. In many cases, individuals or teams are spending days each month gathering data from multiple sources for reporting to their constituents. We are reducing these times to minutes by automating many of the data collection and integration processes that were previously manual.
Pricing and functionality. Tableau Desktop is a very capable self-service business intelligence and analytics solution. The very rich visualization capabilities are far superior to that of Excel and Power BI. However, the pricing for the Power BI desktop is extraordinary. If you own Excel 2010 or 2013, you can download the functionality for free. And more often than not, the visualization capabilities of Excel are quite good enough. Another reason we selected Power BI is the shallow learning curve for users, compared to Tableau and other similar solutions. Excel is very familiar to most data analysts and finance/accounting teams. It is a comfortable environment on which to add powerful analytic capabilities.
If I were a small business owner, I would likely use Power BI for Office 365 for the sheer fact that I would get the Office licensing I need, along with powerful capabilities. As a Microsoft Partner, we continue to see Microsoft invest heavily in the Power BI capabilities, and will continue to implement and support BI solutions around this product, as we believe this is in the best interest of our clients.
Return to navigation