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.

DirectQuery is a method of connecting your data directly, i.e. any changes in data 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, which are supported by Power BI with DirectQuery. Although Microsoft keeps working on adding different data sources in DirectQuery (currently only six data sources in this method and three more in Preview), that's why I feel that still DirectQuery (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. If you are an Excel and SQL user, then it is very easy to get a 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. 238,917 professionals have used our research on 5,955 solutions.
Why do you like it?

Sign Up with Email