SSAS tabular memory reporting

  1. Create a new data collector set in Windows Performance Monitor to capture SSAS tabular memory counters:
SSAS Memory Counters in a Performance Monitor Data Colletor Set
  1. Set the Log format of the collector set to Comma Separated.
  2. Open a new Power BI Desktop file to be used for both the SSAS Tabular and on-premise data gateway counters.
  3. Create data source parameters for the server, database, and number of days of history to retrieve.
  1. Define a query that exposes the database objects (AdWorksProd) and Date and Time queries that retrieve these views.
Parameters and Queries Used to Retrieve Date and Time Dimension ...

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.