I am looking for some opinions and suggestions re Microsoft BI Architecture. Need to design a BI architecture that supports:
- Self-Service BI - thinking of Power BI
- Enterprise Level modelling with proper source control, data security and multi-lingual support - thinking of Analysis Services
- Standard Reporting (paginated reports)- thinking of SSRS or Power BI Report Builder
- Hybrid Infrastructure - both on premise and cloud data sources, including MS SQL, Azure and SAP BW and SAP HANA
So I have identified the products I need. The problem is - they are part of different services. For now it looks that we would need:
Option 1) Power BI Premium to support Paginated Reports and Self-service BI and Separate Analysis Services for modelling (Power BI Premium lacks key features like multi-language support, column/object level security, enterprise level AML).
Option 2) Power BI Pro for Viz and self-service BI, SSRS for Paginated Reports and Analysis Services for Modelling. However here I am not sure if SSRS is available on Azure. And how easy it would be to manage three different products, especially if data is residing on premise and in the cloud.
Anyone had to do similar exercise? What have you've chosen? For now, I would love to avoid having to purchase Power BI Premium, but I do need to support paginated reports and maximise the use of Power BI PRO licences (hundreds of users).
Thank You!
