Microsoft Power BI vs Microsoft SQL Server Reporting Services comparison

"The solution is very easy to use."

"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."

"Very intuitive and easy to use."

"It is a little easier at buildings charts and graphs than Tableau."

"I find Power BI's reporting feature the most valuable. The solution has improved a lot. There are new features getting added day by day. In the past, they didn't even have the printing feature, but now they have it."

"MS SQL & SQL Server Analysis Services."

"Its ease of use is most valuable."

"It's a straightforward setup."

"The tool's valuable features are its drill-down feature, graphs, and charts."

"The initial setup is easy."

"We can create quality reports in real time."

"It is a stable solution."

"The SQL Server Reporting Services makes it very easy to get the data whenever we need it."

"In Microsoft SQL Server Reporting Services, the installation and configuration are easy."

"I'm very satisfied with the customer service. And usually, whenever we have any issue or details, we get to the person for the support. I'm really satisfied with the service. Within a few minutes or within a few hours, the support person will be available."

"I am impressed with the product's seamless integration. It can work with different databases like Oracle."

"The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."

"When you go to the cloud, its licensing is not intuitive. It is a little bit complex. When you have to purchase a new license, it is difficult to understand on their website what exactly you need to pay and how you can group. It is something that is applicable to all Microsoft products. They're not always so simple and clear when it comes to licensing. Their support can also be better in terms of explaining how they resolved an issue and what steps they took to resolve it. They are able to resolve the issue, but they can be better at explaining the approach they took to resolve the issue. It could have something in the direction of machine learning. It can have some kind of integration with machine learning where you can ask for some reports with natural language."

"At times, I feel that the system needs improvement in single sign-on, especially for the on-premises side of the tool."

"Power BI could have better metadata management. It's easy to use for a single person. However, it lacks an enterprise-grade metadata management system, which can be a problem if you're doing an enterprise deployment with multiple users."

"Microsoft BI lacks some of the scheme features. It would be beneficial if there were a way to show how we move values in a different way."

"Power BI shows reports on actual data, not metadata."

"If you need data in real-time, it's not an ideal solution."

"It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."

"Sometimes, we need to make sure that the configuration stays consistent across the reporting instances. They all connect to the same database. So, it shares that same backend, but the reporting services itself can also be configured. On the application level, for reporting level. And it is, based on my own experience, it is a manual effort to make sure that the reporting servers are configured the same across the environment."

"Tableau is more user-friendly because it doesn't need to do any extra programming. It has drag-and-drop functionality."

"The setup is difficult because you have to install different servers."

"It would be really nice to have better integration between the solution and Power BI."

"The complex tuning for report performance is complicated. There is a lack of native support for source code control. We often need to use separate tools like VS Code or other software to manage version control and changes in the database. It would be beneficial if source code management were integrated directly into SSRS, thus eliminating the need to rely on external tools. While CLI-based operations are exemplary, the trend is towards GUI for a better user experience. Integrating both visualization and source code management within SSRS would simplify the process for users."

"The solution's interface is old."

"The product could be improved by reducing the time it takes to build and deploy reports."

"It is not easy to integrate the product with other tools in the market."

"The price of the solution can be expensive if you want to synchronize your data more."

"Downloading Power BI Desktop is free."

"The solution's pricing is medium."

"From a cost point of view, it's competitive in the enterprise space, although it's not as competitive when you add up all of the additional costs. Things like integrations cost extra and it's probably where Microsoft makes more of the money."

"Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI."

"It would be better if the price was cheaper."

"Power BI is cheaper than Tableau and Cognos."

"I have never worked on licensing, but I have heard that it is reasonable."

"The solution is cheaper than its alternatives."

"The solution is expensive."

"The price is pretty good."

"Value-wise, the solution's pricing is good for the price that we pay."

"The solution is free to use for developers."

"The pricing is high."

"The product pricing is reasonable in terms of suitable features for business."

"The tool's licensing costs are expensive."