What is most valuable?
The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views.
I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use.
What needs improvement?
A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it.
The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation.
There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution.
For how long have I used the solution?
I have been using this solution for more than four years.
What do I think about the stability of the solution?
It is stable. I haven't found it hanging. It consumes a lot of memory on the local system but not while developing the reports. It also depends on the data on which we are working, but generally, it is light and stable.
How are customer service and technical support?
My overall experience with Microsoft is actually quite good. We have contacted their technical support once or twice. It was something related to the Power BI visualization, where we needed to visualize some data, but they had some kind of limitation in personalization. We also wanted to connect Power BI with other servers, but we were facing some performance issues. The reports were not working fine. I don't think they managed to solve our issues.
Which solution did I use previously and why did I switch?
I have worked on SiteSense and Oracle OBIEE. I feel more satisfied when I'm working with Power BI. It is more convenient as compared to other solutions.
How was the initial setup?
The initial setup is easy. I didn't find any complexity in it. It can be difficult if the end users don't know how to use it. If they are trained on it, then after a week or a month, it gets easier for the end users.
What's my experience with pricing, setup cost, and licensing?
Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable.
It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version.
What other advice do I have?
I would rate Microsoft BI a seven out of ten.