Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Refresh not working for OAuth based Custom Connector in Power BI Service

Hi, we developed a custom connector for Power BI. It works fine perfectly in Power BI desktop. But, it doesn't work so in Power BI service. Both Manual and Scheduled reason fails for anonymous reason...
Need Help
Show and Tell
Tutorial Requests
EHP's avatar
EHP
Icon for Advocate I rankAdvocate I
5 years ago

Hi everyone! 

 

I found the answer here:
https://community.powerbi.com/t5/Report-Server/Query-contains-unsupported-function-Function-name-Web-Contents/td-p/887698

 

Essentially my query needed splitting into base url and relative path.  I was still able to keep a variable in the base url, which made environment switching much easier.  This is an edited code snippet:

environmentName = "dev1"

GetJobsData = ((offsetAmount as number) as record =>
let
    Source = Json.Document(Web.Contents("https://" & environmentName & "myURL.net",
    [
        RelativePath = "api/jobs" & "?offset=" & Number.ToText(offsetAmount)
    ]))
in
    Source),

Hope this helps!