Forum Discussion

Mitsql's avatar
Mitsql
Icon for Advocate II rankAdvocate II
8 years ago

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

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 # ...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
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's avatar
Mitsql
Icon for Advocate II rankAdvocate II
8 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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.