Refresh issue with SharePoint.Tables called based on column

[kbrouder]

I have a table with a list of SharePoint URLs, I need to call a specific list in each site. The list is always the same, the only thing that is parameterized is the URL of the site. 

I originally built this really nice with a function, however, the refresh would not work in the Power BI Service.

So I rebuilt it without the function, however, it is STILL not refreshing in the service. I get this message with no details: "You can't schedule refresh for this dataset because one or more sources currently don't support refresh"

Here is a simplified version of what the query looks like (even this simple form doesnt work):

let

Source = 
#table(
{"URL"},
{{"https://sharepointurl"}}
),
#"Added Custom" = Table.AddColumn(Source, "SharePointResults", each SharePoint.Tables([URL], [ApiVersion = 15]){[Title="ListName"]}[Items])
in
#"Added Custom"

I would go from this and expand the table etc. It all works great in the desktop, but doesnt work in the service, which makes this useless. Any ideas?

[v-sihou-msft]

@kbrouder

In this scenario, you have multiple sources within this query. It's not supported to refresh the source as a argument in function. See slimilar threads below:

http://community.powerbi.com/t5/Desktop/You-can-t-schedule-refresh-for-this-dataset-because-one-or-m...

https://www.excelando.co.il/en/power-bi-cant-schedule-refresh-when-source-is-multiple-excel-files/

Please vote this idea.

[kbrouder]

Hi @v-sihou-msft,

Appreciate the response, As you can see I pulled out the function and just called the second query directly. I had already previously looked through those threads, I cant seem to figure out how to apply their workarounds to The SharePoint.Tables query.

Is it possible to apply the same logic to my query?

[kbrouder]

I have tried every work around I can think of, anyone know if this is possible?