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...
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?