Need some input for "This API can only be called on a Model-based dataset"

[Mitsql]

I am trying to refresh dataset using POST method and got this error while running PS script.

    # This sample script calls the Power BI API to progammtically trigger a refresh for the dataset
# It then calls the Power BI API to progammatically to get the refresh history for that dataset
# For full documentation on the REST APIs, see:
# https://msdn.microsoft.com/en-us/library/mt203551.aspx 

# Instructions:
# 1. Install PowerShell (https://msdn.microsoft.com/en-us/powershell/scripting/setup/installing-windows-powershell) and the Azure PowerShell cmdlets (https://aka.ms/webpi-azps)
# 2. Set up a dataset for refresh in the Power BI service - make sure that the dataset can be 
# updated successfully
# 3. Fill in the parameters below
# 4. Run the PowerShell script

# 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 = " FILL ME IN " # the ID of the group that hosts the dataset. Use "me" if this is your My Workspace
$datasetID = " FILL ME IN " # 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 = " FILL ME IN " 

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

# Calls the Active Directory Authentication Library (ADAL) to authenticate against AAD
function GetAuthToken
{
       $adal = "${env:ProgramFiles(x86)}\Microsoft SDKs\Azure\PowerShell\ServiceManagement\Azure\Services\Microsoft.IdentityModel.Clients.ActiveDirectory.dll"

       $adalforms = "${env:ProgramFiles(x86)}\Microsoft SDKs\Azure\PowerShell\ServiceManagement\Azure\Services\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

       $authResult = $authContext.AcquireToken($resourceAppIdURI, $clientId, $redirectUri, "Auto")

       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

[Greg_Deckler]

Are you trying to use this against a Live connection?

[Mitsql]

I am trying to use it with Directquery dataset. Basically, would like to minimize 15 mins auto refresh and trying to refresh dataset every 5 mins by calling refresh endpoint.

Thanks..

[Eric_Zhang]

---

@Mitsql wrote:

I am trying to use it with Directquery dataset. Basically, would like to minimize 15 mins auto refresh and trying to refresh dataset every 5 mins by calling refresh endpoint.

Thanks..

---

@Mitsql

1. The dataset refresh API doesn't support DirectQuery mode dataset. Actually the reports in DirectQuery mode retrieve the latest data everytime you access them, you don't refresh them. If you're talking about the direct query cache, AFAIK, you can only use the default setting intervals.
   
2. For other datasets not in DirectQuery mode, the REFRESH api is also limited 8 times(48 times for Premium license) a day.

[Mitsql]

Thanks, @Eric_Zhang & @Greg_Deckler for the prompt reply...

I have schedule cache refresh for 15 mins (want it to go by 5 mins but min option here is 15)

Is there a way I can refresh directquery dataset every 5 mins?

Highly appreciate your help.

[Greg_Deckler]

My understanding of DirectQuery is that you are live querying the data set at the time of report rendering. However, that probably really means querying the cache of the dataset as you indicate. If you can't get the cache to update faster than 15 minutes and you need more immediacy, the only other thing that I can figure is if you can create a streaming data feed and wire it up to Power BI.