Forum Discussion
Refresh issue with SharePoint.Tables called based on column
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?
3 Replies
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:
https://www.excelando.co.il/en/power-bi-cant-schedule-refresh-when-source-is-multiple-excel-files/
Please vote this idea.
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?
I have tried every work around I can think of, anyone know if this is possible?
