SSAS design considerations

Data models

1. SSAS Multidimensional (multidimensional)
2. SSAS Tabular (tabular)
3. Power Pivot (tabular)
4. Power BI Desktop (tabular)
5. PowerBI.com (tabular)

The last one does not allow relationships to be set, so it is better to publish one of the first four to PowerBI.com

Read more...