Forum Discussion

Namnami's avatar
Namnami
Regular Visitor
9 years ago

Power BI and SSRS

We currently have SSRS 2008 R2 and Sharepoint performance point dashboard using SSAS 2005 cube. We want to start using power BI (mainly instead of the performance point dashboard).   What is the r...
Report Server
SSAS
SSRS
muchinski's avatar
muchinski
Resolver II
9 years ago

Hello,

 

Power BI Report server is a superset of SSRS. In other words: it supports all the SSRS features, plus Power BI Reports.

The license models are also different, but if you have SQL Server Enterprise Edition plus Software Assurance, you can install the Power BI Report Server instead of the normal SSRS. (you can also use Power BI Report Server if you have a Power BI Premium subscription)

 

Just keep in mind that you will need to upgrade your cubes to at least SSAS 2012, due to that Power BI send DAX queries (not MDX) to SSAS; so, your cubes on SSAS 2005 will not works as a proper source for Power BI.

 

My tip: Read a lot about that (it really worth) and install the Evaluation version: https://powerbi.microsoft.com/en-us/report-server/