Refresh Issue

[PoweredOut]

Hi

I am trying to refresh data that I have pulled from HubSpot API. I get this issue.

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.

I have tried Chris Webb's https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i... using releative path but this throws an error

where in my query below should i build this in? 

each [WebCall = Json.Document(Web.Contents("https://api.hubapi.com/contacts/v1/lists/all/contacts/all?"& "&property=firstname" & "&property=lastname" & "&property=jobtitle" & "&property=email" & "&property=associatedcompanyid" & "&property=associatedcompanyid" & "&property=job_level" & "&property=hs_object_id" & "&property=hs_social_last_engagement" & "&count=100" & "&vidOffset="&Text.From([Last_Key])&"", [Headers=[ContentType="application/json", Authorization="Bearer myapikey"]]))

Thanks 

[lbendlin]

As described in his subsequent article.  Handling Multiple URL Query Parameters With The Same Name Using Web.Contents In Power Query/Power BI...

each [WebCall = Json.Document(Web.Contents("https://api.hubapi.com/contacts/v1/lists/all/contacts/all",
[Query = [property={"firstname","lastname","jobtitle","email","associatedcompanyid","job_level","hs_object_id","hs_social_last_engagement"}, count="100", vidOffset=Text.From([Last_Key])], Headers=[ContentType="application/json", Authorization="Bearer myapikey"]]))