Power BI Desktop is a versatile tool that can be used for modeling and reporting. When a model already exists, the tool can be used to simply develop a report which sources the model. However, when a model is required, it provides three development choices: Import, DirectQuery and Composite (in preview). In this presentation, the four Power BI Desktop modes will be introduced, described and demonstrated. Also, guidance will be provided to help you choose the appropriate mode for your project.
In this presentation, you will learn:
- How to develop a Live Connection report
- How to develop an import model
- How to develop a DirectQuery model
- How to develop a Composite model
- How to determine the appropriate Power BI Desktop mode for your project
YOU MAY ALSO LIKE:
The Four Modes of Power BI Desktop
Peter Myers is from Melbourne, Australia and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and provides mentoring, technical training, and training course content authoring for SQL Server, Office and SharePoint. He has a broad business background supported by a Bachelor’s degree in applied economics and accounting, and he extends this with solid experience backed by current MCSE certifications. He has been a SQL Server MVP since 2007.