Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Incremental Refresh

Hello all   I'm sure there will be a load of incremental refrsh questions with it's launch, and here is mine.   I'm having issues with refreshing my entire Google Analyitcs data, and it looks lik...
Need Help
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

For the parameter issue, please referring:

1. https://community.powerbi.com/t5/Service/Parameters-arent-detected-in-Power-BI-Services/td-p/643948 

2. If you are using the parameter in the Web.Contents function, such as following:

 

let
    Source = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/groups/" & id &"/datasets/" & [datasetid] & "/refreshes",[Headers=[Authorization="Bearer " & TokenParameter]]))
in
    Source

 

Try to use the Relative Path parameter to included all the dynamic part of the url, such as following

 

let
    Source = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/groups/",[RelativePath=id &"/datasets/" & [datasetid] & "/refreshes",Headers=[Authorization="Bearer " & TokenParameter]]))
in
    Source

For the Resource name and Location need to match.

can you try this:

  1. delete your dataset from the service
  2. open the desktop file and hit Refresh (5th icon in the Home ribbon)
  3. Use GetData from the service to publish the desktop model again (I still don't trust the Publish feature from the Desktop)
  4. Go to Schedule Refresh->Manage Datasources and enter credentials for all your connections
  5. try Refresh Now and see what happens

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-diye-msft 

     

    I have completed the steps in the link you included in your response, as well as completing the 5 steps you requested, however the Power BI Service still does not recognise the fact that my report contains parameters.

     

    What else can I try?