Forum Discussion
Using SSRS today, SSAS or Power BI tomorrow?
Hi, I'm currently using SSRS for generating reports from a Microsoft SQL Server. At the moment I need to write new queries when generating a new report, but I'd like to have a more self service or...
Power BI is quite weak for displaying tables right now. Also it is not available on-prem right now, so the web service has to be hosted via MS Azure cloud service. Besides those 2 issues, Power BI is better, more modern, more self-service oriented, ... etc.. For me, it is THE reporting tool.
Power BI will also be available on prem soon:
Also SSRS will be integrated with Power BI at some point in time:
https://ideas.powerbi.com/forums/265200-power-bi/suggestions/6897219-integrate-ssrs-reports
You can connect Power BI to a number of different sources. This can either be:
a) on prem SQL
b) azure SQL DB
c) AS Tabular
d) AS Multidimensional
E) Azure DWH
etc.
The variety and number of sources is really neat.
Hope that helps for the start.
BR