Forum Discussion
Power BI over bigger on-premise database
Yes, it is very fast and live queries over SSAS cubes works incredibly well and is fast. It sounds like in your case this will be even better once you can render Power BI reports directly on-premises in SSRS.
Thank you.
Hi papanovn,
A quick question would be is have you tried to create a Power BI model and see how much memory it actually consumes?
I have no doubt that you are on track that it will be very large. But until you actually try and see how efficient the Vertipaq question is in terms of compression. As well as what data you need to bring into the Power BI model.
I also would suggest that for larger implementations they do suggest having a SSAS Tabular Model On-Premise and then connect using Live Query. This enables everything to run as efficiently as possible and still leverage the Vertipaq memory engine.
Microsoft announced Power BI Premium – a capacity-based licensing model that increases flexibility for how users access, share and distribute content in Power BI. The new offering also introduces the ability to manage Power BI reports on-premises with the included Power BI Report Server. Power BI Report Server delivers the capabilities we made available in January 2017 as the Technical Preview for Power BI Reports in SSRS. Power BI Report Server is an on-premises server that enables Power BI Pro users to publish Power BI reports and distribute them broadly across the enterprise, without requiring report consumers to be licensed individually per user. Organizations now have the flexibility to publish their Power BI reports to the cloud (Power BI service), or manage them on-premises (Power BI Report Server) and move to the cloud at their pace.