please check this link:
maybe you solve your problem
MS recently announced Power BI Premium which support dedicated powerbi service resources as well as on-premise deployment of power BI reports on top of Power BI report server. One of the things in the offering is no need for per user costing. Check out Power BI Premium license.
SSRS is part of the Microsoft "BI stack" and is part of SQL Server. When you install SQL Server you have the option to include different parts of the BI stack including SSIS, SSAS and SSRS. You can, in part, manage SSRS from SQL Server Management Studio as it's very integrated with SQL Server. SSRS runs as a service on a server you control (either a local physical or virtual server, or in the cloud). SSRS is free when you have a SQL Server license.
Power BI (which I have never used and don't know much about) is cloud based and is part of Microsoft Office 365. It runs in the cloud on hardware that you have less control over.
I have been working with SSRS for years. What makes it great is how it's pretty solid and stable. I can put together and publish a report in minutes and it will work. SSRS hasn't changed very much which means if you know one version you'll be able to manage them all. SSRS, however is old and tired. It's interface is outdated and crusty, you have minimal control over how parameters behave or appear. You can't use SSRS for slick looking charts and graphs, that functionality in SSRS is very week compared to what's available today.
Power BI on the other hand is extremely slick. The stuff I've seen created with Power BI is pretty amazing. It's certainly more modern and current.
On the flip side, for ever Power BI veteran, there's 20 people with many years of SSRS experience. There's more SSRS material. Note, for example, SSC has a Stairway for SSRS but not Power BI.
I hope this will helps you. Thank's for reading.
This is the best answser. Many professionals do not realize the diference between operational requirements and analytical requirements. Also the technology behind SSRS and Power BI are totally different and they are oriented to SSRS: Operational and PowerBI: Analytical.
SSRS is for Operational: Print an Invoice, Print an paginated list of detailed rows, get real time information from complex sql queries.
You cannot do the above with PowerBI. Instead PowerBI you can interact with slicers and filtering, and add summarized information to Tabular, Multidimensional or imported mode.
SSRS and Power BI has different sources:
Power BI as analytical model using uses Tabular, Power Pivot or Multidimensional , imported or Direct Query mede is oriented to get summarize data from measures.
In SSRS you can use the database directly as a source and generate an multitable joins with subqueries like you can do in SQL. It is efficient when you need to get 10,000 rows and 200 columns and with formulas.
Try to get 10,000 rows and 200 columns with Dax Measures comming from different tables and it simply does not run. Nothing bad with the tool, it is just not designed to do detailed massive reporting.
I would like to ask a question specific to our business as we are not able to make a decision to choose the appropriate Reporting tool for preparing reports for our business.
There is requirement to prepare reports at specific schedules in the year i.e. Month End Reports, Quarterly Reports and Yearly Reports. We have two options (SSRS & Power BI) for preparing the reports, however, we have to choose one.
Can you please give some suggestions for this scenario?
A company that needs to distribute reports and analytics to a medium number of users, with complex business logic and drill down capabilities. Then you should use ...SSRS
A company, an individual, a small group of users who need to compare data from many sources, analyze data, manipulate data, build custom visualizations of data, share them with other user and draw a synthesis from data. Then you should use ...Power BI
SSRS is better on delivering detail/operational schedule report:
Also, SSRS use SQL query so you don't have to re-learn DAX .
Power BI for Reporting Services is only 'free' when you have an Enterprise Agreement with Microsoft and are using SQL Enterprise. It does work well for on premises scenarios and there is a lot you can do that the Power BI Service does. You have the flexibility of self service power bi reports as well as being able to create and publish SSRS reports.