In a Power BI or Analysis Services model, you can use different technologies to connect to your data: DirectQuery to connect to the source directly, aggregations to speed up DirectQuery connection or VertiPaq to load data in the optimized engine. Each technology comes with features and limitations. In this session we analyze the advantages and disadvantages of the technologies, their realistic speed and possible use cases, through demos on a real data model.

The goal is to let you make an educated choice when deciding the architecture of your data model.

The video is not available to view online.