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.
Excellent program for manipulation and presentation of statistical data.
Powerful, easy to use, no-nonsense visualization
PowerBI for your dashboard and reporting needs.
BI by Microsoft
Power BI - Worth the O365 Upgrade
I love Power BI but I could love it more
Power BI Review
Power BI to reduce BS!
PowerBI.Com - Quick Review
Find the POWER
Power BI worth a look? YES!
Almost there
Just BI
Power BI for Office 365 - A compelling data analytics platform for personal and team use
We are a Microsoft partner, with my line of business focusing on creating data-driven solutions for our customers, ranging from …
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
- Report sharing and collaboration (11)10.0100%
- Drill-down analysis (11)9.090%
- Formatting capabilities (11)9.090%
- Customizable dashboards (11)8.080%
Video Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Power BI For Office 365 (discontinued), and make your voice heard!
Pricing
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…
Features
BI Standard Reporting
Standard reporting means pre-built or canned reports available to users without having to create them.
- 9Pixel Perfect reports(10) Ratings
Pixel Perfect reports are highly-formatted reports with graphics and ability to preview the report before printing.
- 8Customizable dashboards(11) Ratings
Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.
- 10Report Formatting Templates(8) Ratings
Ad-hoc Reporting
Ad-Hoc Reports are reports built by the user to meet highly specific requirements.
- 9Drill-down analysis(11) Ratings
Drill down analysis is the ability to get to a further level of detail by going deeper into the hierarchy.
- 9Formatting capabilities(11) Ratings
Ability to format output e.g. conditional formatting, lines, headers, footers.
- 10Integration with R or other statistical packages(6) Ratings
Integration with the open-source R predictive modeling environment.
- 10Report 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.
- 10Publish to Web(11) Ratings
- 10Publish to PDF(10) Ratings
- 9Report Versioning(6) Ratings
Report versioning is the assignment of version numbers to each version of a report to help in tracking.
- 9.6Report Delivery Scheduling(4) Ratings
Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.
- 8.7Delivery 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.
- 10Pre-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.
- 10Location Analytics / Geographic Visualization(11) Ratings
Location analytics is the visualization of geographical or spatial data.
- 10Predictive 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.
- 10Multi-User Support (named login)(10) Ratings
Named model access means that users have access based on name and password.
- 9Role-Based Security Model(8) Ratings
Role-based access means that access to data is determined by job or position in the corporation.
- 10Multiple Access Permission Levels (Create, Read, Delete)(9) Ratings
Multiple access permission levels means that different levels of users have different rights.
- 10Single 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.
- 10Responsive Design for Web Access(10) Ratings
Web design aimed at producing easy-to-read sites across a range of different devices.
- 9Mobile Application(9) Ratings
A dedicated app for iOS and/or Android.
- 10Dashboard / Report / Visualization Interactivity on Mobile(9) Ratings
In-app dashboard reports and data visualization.
Application Program Interfaces (APIs) / Embedding
APIs are a set of routines, protocols, and tools for used for embedding one application in another
- 9REST API(2) Ratings
REST is an architecture style for designing networked applications
- 8Javascript API(2) Ratings
A Javascript API is a type of API
- 8iFrames(1) Ratings
An iFrame is an HTML document embedded inside another HTML document on a website
- 8Java API(1) Ratings
A Java application programming interface (API) is a list of all classes that are part of the Java development kit (JDK)
- 7Themeable User Interface (UI)(2) Ratings
A themeable user interface means that a specific visual them can be applied to it
- 7Customizable Platform (Open Source)(2) Ratings
A customizable, open source API Gateway is a fast and scalable type of API
Product Details
- About
- Tech Details
- FAQs
What is Power BI For Office 365 (discontinued)?
Power BI For Office 365 (discontinued) Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(215)Attribute Ratings
Reviews
(1-15 of 15)Microsoft cloud based amazing Reporting tool for
- 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)
but if you need to build snapshot kind of logic and need to maintain the history then this tool will not work.
- 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
- Need to have more advanced knowledge in excel
- Some elements are limited
Powerful, easy to use, no-nonsense visualization
- 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.
- 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.
PowerBI for your dashboard and reporting needs.
- 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.
- 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.
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.
BI by Microsoft
- perfectly integrated with microsoft tools
- objects can be easily shared in mobile environments
- attractive dashboards
- 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
Power BI - Worth the O365 Upgrade
- 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.
I love Power BI but I could love it more
- 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
Power BI Review
- Beautiful visuals
- Ease of use
- Powerful data manipulation language
- 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!
- 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.
- 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.
PowerBI.Com - Quick Review
- Easily create graphs and visualizations.
- Distributing dashboards & content packs
- Finding inconsistencies in data.
- 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.
Find the POWER
- We can view our whole business on one dashboard which we share at meetings
- There report views are outstanding but could use more colour options
- We are trying to embed their visuals for our app on mobile
- I can not seem to find out how to export their files in other formats
- They use SQL but we are moving to non SQL servers soon
- Sometimes the data gets too squished on small monitors
Power BI worth a look? YES!
- Drag and drop report development
- Flexibility with Power Views, Pivot Tables, ETL, and Data Modeling all in one
- Price
- Power View is still in the early stages, so customization of the look and feel is a bit limited.
Almost there
- Ease of use. Most people have experience working with Excel. If you know how to create pivots, you can use Power BI.
- Data extraction and transformation (ETL). ETL is a joy with Power Query. It is intuitive, simple and a magical experience to transform poor data into something useful.
- Visuals. Power BI is beautiful to behold, especially Power View.
- Maps. The interactive maps are great built-in tools.
- Cost You cannot find anything cheaper than Power BI, unless you want to give it to every user in your company.
- Automatic updates. A choice of a daily or weekly refresh is too slow for this era of real-time updates.
- Speed. It takes a while to load all the data into memory. Data with more than one million records will take a few minutes to refresh. Once it is loaded, it starts being fairly fast.
- Changing queries in Power Query. Although Microsoft is working on it, when you delete a step in Power Query, you might have to rebuild your data model. This defeats the purpose of having a fantastic user interface, in which it is simple to change queries.
Just BI
- It's a self service BI. It's very easy to discover, analyze and visualize data.
Power BI for Office 365 - A compelling data analytics platform for personal and team use
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.