Analysis Services Integrated

The same columnar, in-memory OLAP database engine used by Analysis Services Tabular models and Power BI datasets is now built into the Power BI Report Server. This engine is used to render Power BI reports containing imported data (import mode) and DirectQuery connections. Therefore, if import mode Power BI datasets (PBIX files) will be deployed to the report server, especially large import mode files (100 MB+), a significantly greater amount of RAM will be needed on the server hosting the Power BI Report Server instance than typical reporting services deployments. Additionally, the Scheduled refresh operations for these large import mode reports will require both RAM and CPU resources, and this should be planned for.

The requirement for additional RAM could be significantly mitigated if the Live connections to Power BI datasets feature described in Chapter 5, Creating and Formatting Power BI Reports, is made available in a future release of the Power BI Report Server. In this scenario, similar to Power BI service deployments, a single import mode dataset (PBIX file) and it's data refresh process could support many Power BI reports.

Alternatively, if the Power BI reports deployed to the Power BI Report Server will use Live connections or DirectQuery connections to data sources, the Power BI Report server will have significantly lower resource requirements. As with deployments to the Power BI service, the main driver of performance for Live connection and DirectQuery reports will be the data source receiving the query requests from the Power BI Report Server.

Table of Contents for Analysis Services Integrated

Create new playlist

Sign In

Sign Up

Table of Contents for
Analysis Services Integrated