Microsoft previews free, updated Power BI business intelligence tool

A new edition of the company's data visualization tool is now freely downloadable

James Phillips, General Manager for Data Experiences, Microsoft. Corp.

James Phillips, General Manager for Data Experiences, Microsoft. Corp.

Aiming at a mass business-user audience, Microsoft has released a preview of the next version of its cloud-based data visualization software, Power BI, with a promise to maintain a free option even after its general release.

Starting Tuesday, businesses can sign up at to test it (the first version premiered last February). A free version of the software is available immediately from the Apple App Store for the iPad. Power BI will also be available for free later this year for the iPhone, Android, and Windows 10.

Through a free, downloadable component of the software called Power BI Designer, users can produce dynamically updated dashboards, with interactive, animated charts of corporate data. The software is designed so that elements of those dashboards can be easily shared with other Power BI users, with or without Excel. A variety of connectors allow Power BI users to set up live links to a wide range of data sources.

A version of the software called Power BI Pro, with additional data capacity and enterprise features, will be made available to subscribers at $9.99 per user per month, effective Feb. 1.

"Power BI allows business users to directly connect with their data," said James Phillips, a Microsoft general manager. "In the past, if I wanted to use business intelligence, my data was locked up by IT, or sitting inside of an SAP system or a Teradata warehouse or a SQL Server data analysis cube."

Today, the data being used to run businesses is, more and more, hosted by cloud-based software like Salesforce, Workday, and SuccessFactors. That data is now accessible by way of login credentials and public APIs, in a way that even on-site data has not been before, Phillips continued.

A new wave of BI tools, including Tableau, Pentaho, Sisense, and Qlik, aims to help companies make sense of their growing abundance of data, both on-site and in the cloud. Last year, analyst firm Gartner gave Microsoft grief for not having updated -- and discounted -- its BI suite in the face of more powerful, cloud-based competition, as well as for placing too much leverage on Excel for its reporting functions.

"There's a transformation that is occurring on the business user side -- it's not data science and propeller-head stuff, but it is becoming more data-aware, more data-centered," said Phillips. "And as tools like Power BI allow you to connect people with data effortlessly, you set up the ability for people to become more data-conscious and data-driven... versus a world where everything is intuition, and everyone runs on gut, and you think you know what the answers are but you don't have the ability to measure and understand whether you are right."

In a product demonstration, Phillips showed how PowerBI enables a company with a Microsoft account to log onto a data visualization service hosted by Azure, and in minutes, authorize that service to connect to cloud-based or on-site data sources. (Anyone who has a U.S. business email account can use the preview version.) The particular data source he showed off was Salesforce, where companies' global sales performance data is kept in real-time.

Seconds after making the connection, PowerBI estimated which types of charts would be most meaningful for drawing correlations between elements of connected data. In moments (under 30 seconds, in Phillips' demo), the system produced a surprisingly complete dashboard with live, animated, interactive charts, inside the user's browser. Since the chart is rendered using HTML5, Internet Explorer can be used though is not required.

"Now we're connecting live with Salesforce," Phillips said, "so I'm logging on with my credentials, I get the data that I have permission to see, and we're creating a new dashboard. There's my data, out of Salesforce, just like that. It did not require me to go to an analyst or to a business intelligence technical professional. I got connected with data that was available to me immediately.

Power BI allows users to gain insight from the data they already have in existing data analysis systems such as Hadoop and Azure Stream Analytics, Phillips emphasized, saying, "it doesn't mandate that you run off and re-architect your world; it meets you where you are and pulls you forward."

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Tags James PhillipsservicesMicrosoftComputing servicesreportingbusiness management

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Scott M., Fulton III

IDG News Service
Show Comments

Most Popular Reviews

Latest News Articles


PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?