SSRS

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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial