Microsoft 400x400

Microsoft BI Review
The interactive reports, DirectQuery and integration with the other Microsoft services are valuable features.


Valuable Features:

The interactive reports, DirectQuery and integration with the other Microsoft services are valuable features.

Room for Improvement:

There needs to be support for more data sources in DirectQuery.

Direct Query is a method of connecting your data directly. i.e. any changes in data in source will reflect in report immediately (this is very great feature if you are doing LIVE analysis of your data) As of now there are limited number of Data Sources such as SQL, SQL Azure etc is support by Power BI with direct query. Although Microsoft keep working on adding different data sources in Direct Query(currently only 6 data sources in this method and 3 more in Preview), that's why I feel that still Direct Query (method of connecting your data) has more room for improvement because there are many other data sources that are commonly used by different organization like (MySQL, Access etc)"

Use of Solution:

I have used this solution for two years.

Stability Issues:

In the beginning, we did encounter some stability issues; now, Microsoft is doing great things to make this product more stable and enhanced.

Previous Solutions:

We were using SQL Server Reporting Services (SSRS reports), now we are moving towards Power BI due to its Publish on web part, as well as the interactive cross-filtering throughout all the visuals (i.e., if you need).

Initial Setup:

The setup is easy. It is very easy to use, i.e., if you are an Excel and SQL user, then it is very easy to get grip on this product.

Other Solutions Considered:

We tried Tableau; although Tableau itself is a great product, we chose Power BI due to its pricing and Microsoft's focus to make it a better product.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are Microsoft Gold Partners.

0 Comments

Anonymous avatar x30
Guest

Have A Question About Microsoft BI?

Our experts can help. 229,168 professionals have used our research on 5,846 solutions.
Why do you like it?

Sign Up with Email