TrustRadius: an HG Insights company

Power BI For Office 365 (discontinued)

Score8.4 out of 10

216 Reviews and Ratings

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.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features Power BI For Office 365 (discontinued) has to offer, as determined by TrustRadius' reviewers.
Based on 216 ratings of Power BI For Office 365 (discontinued)'s features
View all features

Top Performing Features

  • Report Formatting Templates

    Category average: 8.1

  • Integration with R or other statistical packages

    Integration with the open-source R predictive modeling environment.

    Category average: 7.9

  • Report sharing and collaboration

    Report sharing and collaboration is the ability to easily share reports with others.

    Category average: 8.5

Areas for Improvement

  • Java API

    A Java application programming interface (API) is a list of all classes that are part of the Java development kit (JDK)

    Category average: 8.1

  • Themeable User Interface (UI)

    A themeable user interface means that a specific visual them can be applied to it

    Category average: 7.8

  • Customizable Platform (Open Source)

    A customizable, open source API Gateway is a fast and scalable type of API

    Category average: 7.7

Reviews

What users are saying about Power BI For Office 365 (discontinued).
View all reviews

Microsoft cloud based amazing Reporting tool for

Incentivized
Shiv Shrotriya
datawarehousing/BI developer in Information Technology at Varian Medical system (10,001+ employees employees)

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)

Return on Investment

  • Customer Satisfaction with dashboards
  • Insights of business
  • low cost compare to other tools such as tableau
  • very low maintenance

Alternatives Considered

QlikView and Tableau CRM (formerly Einstein Analytics)

Other Software Used

QlikView, Tableau Desktop, SAP BusinessObjects Business Intelligence (BI) Platform

Usability

Powerful, easy to use, no-nonsense visualization

Incentivized
Jeremiah MillerView profile
Associate Director IT Infrastructure in Information Technology at Mennonite Central Committee (1001-5000 employees employees)

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.

Alternatives Considered

Tableau Online

Excellent program for manipulation and presentation of statistical data.

Incentivized
Denis Pereira
Programmer Analyst in Information Technology at Alcoa Aluminiun S/A (10,001+ employees employees)

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

Alternatives Considered

Microsoft Office 365

Other Software Used

BMC Remedy Asset Management, Microsoft Teams, Microsoft 365 Business

Power BI Review

Incentivized
Richard LorenzView profile
Manager of Compliance and Business Performance in Information Technology at Computershare Australia (10,001+ employees employees)

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!

Incentivized
Daniel J. LewisView profile
System Administrator in Information Technology at vdiscovery (51-200 employees employees)

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.

Other Software Used

Adobe Business Catalyst, Barracuda Web Filter, Palo Alto Networks PA-3000 Series