Not Able to Schedule Auto Refresh Because of Custom Function

[Anonymous]

Hi, 

Issue: Not Able to Schedule Auto Refresh Because of Custom Function.

let say below is the function:

fn_Sprint = (URL as text) =>

let

      Source =  WebContents(URL)

in 

     Source

and I have table with many rows - let say for example we take 3 rows

now for each row we call this function and pass the URL column of table to the function as parameter.

but when I check in the data source settings, it says "Some data sources may not be listed because of hand-authored queries".

also in the Power bi service getting below error message "You can't schedule refresh for this dataset because the following data sources currently don't support refresh"

Also what I found out is that if we hardcode the value of the URL in the function itself then we are able to Schedule the auto refresh.

fn_Sprint = (URL as text) =>

let

    Source =  WebContents("https://example.atlassian.net/rest/api/3/search")

in 

    Source

so the things is it need some value at the start for the URL, if we have the value then no issue but if there is not URL then there is issue.

How can we solve the this?

I have also tried below thing but it also does not work

BaseURL = if URL = "" then "https://example.atlassian.net/rest/api/3/search" else URL

Is there any one who can help with this?

[ImkeF · Accepted solution]

Hi @Anonymous ,
if your URL is a bit more complex than the one you've posted, then this article might hold some useful tips: 

http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/

[Anonymous]

Hi @ImkeF, Thanks for help, I appreciate it.

[edhans]

Hi @Anonymous - web sources require an on-prem gateway for security purposes. Has the web URL been added to a gateway?

[Anonymous]

Hi @edhans, we are fetching the data from the JIRA API in Cloud. so we don't any any data gateway in power bi.

[Greg_Deckler]

@Anonymous Hmmm. Maybe @edhans or @ImkeF has a thought here. Otherwise, You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".