In this example, a DAX query is used to retrieve 100 customers based on current year sales and to group their purchase activity by calendar month:

  1. Create a new Report Server project in Visual Studio or open an existing one.
  2. Configure a SSAS Tabular Database as a Shared Data Source for the project:
Report Server Project —shared data source Configuration for an SSAS database
  1. Right-click on the reports folder, choose to add a new item, select report, and click on Add.
  2. Rename the new SSRS report and configure its data sources to use the shared SSAS source from step 2.
  3. Right-click on the datasets folder for the report and select Add Dataset ...

Get Microsoft Power BI Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.