Forum Discussion
Using SSRS today, SSAS or Power BI tomorrow?
Anonymous
Many thanks for your quick and good anwers!
So I guess Power BI is the option to go with.
But how is the data model created when I'm implementing Power BI directly with SQL Server?
If I'd connect Power BI with SSRS I guess the reports are still stuck to only show the reports created in SSRS, but with a better interface?
I've searched for a better understanding of this but almost everything I find is regarding how to use Power BI...
"But how is the data model created when I'm implementing Power BI directly with SQL Server?"
It depends on the mode. If you use "import data", you can do all you want, but need primary keys etc. to define the relationships. For the "live connect" it is currently a bit harder: you can only pull in the data and create relationships. It is currently not possible to add calculcated columns or measures. In general you would prefer the live connect, so i guess they are also working on improving the live connect.
"If I'd connect Power BI with SSRS I guess the reports are still stuck to only show the reports created in SSRS, but with a better interface?"
If you use the "on-prem" hosting of Power BI, you can host Power BI Reports on prem and use the SSRS webserver as server. I do not know what it will look like, if you implement the SSRS reports in the Power BI dashboards (azure web service), as the feature has not been relased so far. ;-)