Extending and Enhancing Semantic Models
Previously in Power BI, when using DirectQuery, only a single DirectQuery connection was allowed and no other data connections were possible. Recently, Microsoft introduced composite models, which removed that restriction and brought a number of other improvements and capabilities.
With composite models, two or more DirectQuery sources are now supported as well as any mix of DirectQuery and import sources. Composite models also introduced the ability to configure many-to-many relationships within semantic models. Finally, composite models introduced the ability to set the storage mode for tables.
In this recipe, a report developer wishes to extend and enhance an existing Power BI semantic model with additional sales plan information stored in an Excel file so that actual sales can be compared against planned sales.
Getting Ready
To prepare for this recipe, follow these steps:
- Complete the recipe Implementing a Semantic...
