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 like incremental refresh is going to be a good solution for me.

 

I followed the instructions on the article to set this up, set up my parameters with RangeStart and RangeEnd, and I think everything went really well.

 

I uploaded the dataset, however when I look at the parameters section in the Power BI Service, I get the following message:

"Parameters haven't been defined for this dataset yet. If you want to set parameters, use the Query Editor. Learn more" 

 

The data refresh also failed citing : 

Token Semicolon expected. Start position: (105, 139). End position (105, 141).

and also

Resource name and Location need to match. 

 

(2 different errors on 2 different attempts)

 

I know there's not a lot to go on here, but am I missing something obvious?

 

Any help would be appreciated.

Need Help

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have the same issues...I hope we get more information about that...

  • dharland's avatar
    dharland
    Advocate IV
    6 years ago

    Same issue here:

    Resource name and Location need to match.

    • eduardosoares96's avatar
      eduardosoares96
      Helper I
      6 years ago

      I have the same problem. 

      Token Semicolon expected. Start position: (138, 138). End position (138, 140).

      Anyone get to solve this?

       

  • 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?

  • Sabeeluzzama's avatar
    Sabeeluzzama
    Regular Visitor
    6 years ago

    After creation of the two parameters in query editor, filter the table out. Then select some value in the incremental refresh where it will ask to keep last Year/month/days data.

    It should work. If you are still facing issue, please post with the error.

    Thanks

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Sabeeluzzama 

       

      Thanks for your response. I completed those actions putting the model together, and came up with the error message that I put in my original post.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello All

     

    I was having the followin issue that most have reported in the group . I can confirm that post raising a ticket with Microsoft , this was fixed on the PowerBI service on 12th April 2020. I can confirm that my incremental refresh no longer throws an error message such as "Resource name and Location need to match". 

    Hope this resolves issues for others as well.

     

    Thanks