Power BI ALM Toolkit

Tags PowerBI DARTS

ALM Toolkit is one of the external tools used in Power BI. It is useful especially when publishing a large dataset to PBI Service. Since it only sends metadata, not the whole data, it is much faster than publishing a dataset.

Detailed Information 

Please note that when you change the dataset with ALM Toolkit, the data file is not downloadable from the Service.

Steps

  1. If you don’t have the ALM toolkit yet, download it from here
     
  2. On the Power BI Desktop, go to External Tools > ALM Toolkit
    Choose ALM Toolkit from the External Tools tab

     
  3. It will prompt you to enter the Target location. Under Target, in the "Workspace" box, enter "powerbi://api.powerbi.com/v1.0/myorg/(workspace name)". Enter the dataset name in the "Dataset" box.

    Enter Target info in the Connections dialogue box

     
  4. It will automatically start comparing the datasets. When there is a change, it will show as "Update", "Delete", or "Create" in the Action column.
    ALM comparing datasets in the ALM working window

     
  5. Click "Validate Selection" 
    Validate Selection in ALM Toolkit Home tab

     
  6. Click "Update" to upload the change on the dataset on PBI Service
    Update in the ALM Toolkit Home Tab

     
  7. When it is done updating, the pop-up window will show "Success"
    ALM Toolkit Success window

Additional Resource

Environment

  • PowerBI