Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.