Incremental Refresh

[Anonymous]

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.

[Anonymous]

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

[Sabeeluzzama]

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]

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.

[v-diye-msft]

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]

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?

[v-diye-msft]

Sorry, I have no idea about this. 

Please kindly raise it to the support team for better advice:

https://powerbi.microsoft.com/en-us/support/ 

[Anonymous]

Thank you @v-diye-msft 

I will raise a ticket accordingly.

[dharland]

Same issue here:

Resource name and Location need to match.

[eduardosoares96]

I have the same problem. 

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

Anyone get to solve this?

[Anonymous]

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