Retrieving Refresh Schedules for Specific Datasets

This example demonstrates how to use the Power BI Read Snap to retrieve the refresh schedules for the SalesMarketing dataset from the My Workspace workspace. This example assumes that you have configured and authorized a valid Power BI OAuth2 account (see Configure Microsoft Power BI Accounts).


Retrieve dataset refresh schedules pipeline overview

Download this pipeline.
  1. Configure the first Power BI Read Snap to retrieve all datasets from the My Workspace workspace.

    Leave the Entity ID field empty so that the Snap retrieves all datasets from the workspace.


    Power BI Read Snap settings for all datasets

    The Snap outputs the details of every dataset in the workspace.


    Power BI Read Snap output preview showing all datasets
  2. Add the JSON Splitter Snap to split each record from the Power BI Read Snap's output into a separate document, then configure the Filter Snap to pass only the records whose $name field is SalesMarketing.

    Filter Snap settings

    The Filter Snap's output preview shows that only the SalesMarketing records are passed downstream.


    Filter Snap output preview
  3. Configure the Mapper Snap to pass only the $id field downstream.

    Retrieving refresh schedules for specific entities requires the entity IDs of the target data sources.


    Mapper Snap settings

    The Mapper Snap outputs only the entity IDs.


    Mapper Snap output preview
  4. Configure the second Power BI Read Snap to use the entity IDs passed by the Mapper Snap and to retrieve refresh schedules.

    Power BI Read Snap settings for refresh schedules
  5. Validate the Snap to view the results.

    The Power BI Read Snap outputs the refresh schedule details for the specified entity IDs.


    Power BI Read Snap refresh schedule output preview

To reuse this pipeline in your environment:

  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.