Power View Data Model Optimization

Before a Power View report can be built, you have to have a data model built as a data source.  There are several configuration options to help optimize your data model specifically for Power View.  These configurations and/or optimizations are made within your Power Pivot model or in SQL Server Data Tools on the SSAS Tabular model.

Power View data model optimization is very important for some visualizations to work correctly. We will discuss several of these optimizations in different articles covering the following topics:

• Power Pivot / Tabular Models
  • X-Axis Guidelines
  • Advanced Properties
  • Image Handling
  • Data Categories
  • Table Behavior
• Multidimensional Models
  • Measure Groups
  • Dimensions
  • Unsupported Features
  • Other Considerations