Microsoft BI Architecture: Power BI, Paginated Reports, Analysis Services and Cloud - what is the op

[Anonymous]

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!

[v-kelly-msft]

Hi @Anonymous ,

Based on your requirement,the best choice for you is to purchase a premium license.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Thanks @v-kelly-msft ,

Are you suggesting to use Power BI Premium together with Analysis Services? To meet our Enterprise level modelling  needs (multi-languge meta data support, source control/column,/object/table level security).

Thank You,

Dovilė

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

Yes,I guess so.Power BI Premium together with Analysis Services can satisfy all your demands.

Below is the reference about AS and premium.

https://docs.microsoft.com/en-us/analysis-services/analysis-services-overview?view=asallproducts-allversions

https://docs.microsoft.com/en-us/power-bi/service-premium-what-is

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[KBO]

Hi, may be this link can help you: https://docs.microsoft.com/en-gb/power-bi/whitepapers .
Best, Kathrin