programmatic data refresh using api

Use the following scripts which work perfect,

# Parameters - fill these in before running the script!

# =====================================================

# An easy way to get group and dataset ID is to go to dataset settings and click on the dataset

# that you'd like to refresh. Once you do, the URL in the address bar will show the group ID and

# dataset ID, in the format:

# app.powerbi.com/groups/{groupID}/settings/datasets/{datasetID}

$groupID = "me" # the ID of the group that hosts the dataset. Use "me" if this is your My Workspace

$datasetID = "d9b4fd0c-7ac9-4e5d-be42-76686ce6b2db" # the ID of the dataset that hosts the dataset

# AAD Client ID

# To get this, go to the following page and follow the steps to provision an app

# https://dev.powerbi.com/apps

# To get the sample to work, ensure that you have the following fields:

# App Type: Native app

# Redirect URL: urn:ietf:wg:oauth:2.0:oob

# Level of access: all dataset APIs

$clientId = "Client ID"

# End Parameters =======================================

# Calls the Active Directory Authentication Library (ADAL) to authenticate against AAD

# update the dll files path if the versions are different like 5.1.2

function GetAuthToken

{

$adal = "C:\Program Files\WindowsPowerShell\Modules\Azure\5.1.1\Automation\Microsoft.IdentityModel.Clients.ActiveDirectory.dll"

$adalforms = "C:\Program Files\WindowsPowerShell\Modules\Azure\5.1.1\Networking\Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms.dll"

[System.Reflection.Assembly]::LoadFrom($adal) | Out-Null

[System.Reflection.Assembly]::LoadFrom($adalforms) | Out-Null

$redirectUri = "urn:ietf:wg:oauth:2.0:oob"

$resourceAppIdURI = "https://analysis.windows.net/powerbi/api"

$authority = "https://login.microsoftonline.com/common/oauth2/authorize";

$authContext = New-Object "Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext" -ArgumentList $authority

$UserCred = New-Object “Microsoft.IdentityModel.Clients.ActiveDirectory.UserCredential” -ArgumentList “[email protected]“, “myPassword”

$authResult = $authContext.AcquireTokenAsync($resourceAppIdURI, $clientId, $UserCred).Result

return $authResult

}

# Get the auth token from AAD

$token = GetAuthToken

# Building Rest API header with authorization token

$authHeader = @{

'Content-Type'='application/json'

'Authorization'=$token.CreateAuthorizationHeader()

}

# properly format groups path

$groupsPath = ""

if ($groupID -eq "me") {

$groupsPath = "myorg"

} else {

$groupsPath = "myorg/groups/$groupID"

}

# Refresh the dataset

$uri = "https://api.powerbi.com/v1.0/$groupsPath/datasets/$datasetID/refreshes"

Invoke-RestMethod -Uri $uri –Headers $authHeader –Method POST –Verbose

# Check the refresh history

$uri = "https://api.powerbi.com/v1.0/$groupsPath/datasets/$datasetID/refreshes"

Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET –Verbose