Dataset can not be refreshed in workspace

Hi kemppaik 

In PBI Service the URL you are querying must be static, so you need to split the URL into the root domain, and supply everything else in the Relative_Path parameter, e.g.

api_url = "https://us.api.knowbe4.com/",
RelPath = "v1/phishing/security_tests/" & PSTID & "/recipients?per_page=500",

data= Json.Document(Web.Contents(api_url,
   [ 
     RelativePath = RelPath,
     Headers = ...............
   ]
   )
   )

Refer to Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code Chris Webb's BI Blog (crossjoin.co.uk) 

Regards

Phil