Data is not getting refreshed (SharePoint Version)

[Anonymous]

Hi,

When i am trying to refresh i am getting below error.

I have used below query to get data from Share Point version history

let
Source = (VersionsRelevantSharePointListName as text, VersionsRelevantSharePointLocation as text, VersionsRelevantItemID as number) => let
Source = Xml.Tables(Web.Contents(Text.Combine({
VersionsRelevantSharePointLocation,
"/_api/web/Lists/getbytitle('",
VersionsRelevantSharePointListName ,
"')/items(",
Text.From(VersionsRelevantItemID),
")/versions"}
))),
entry = Source{0}[entry],
#"Removed Other Columns2" = Table.SelectColumns(entry,{"content"}),
#"Expanded content" = Table.ExpandTableColumn(#"Removed Other Columns2", "content", {"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"}, {"content"}),
#"Expanded content1" = Table.ExpandTableColumn(#"Expanded content", "content", {"properties"}, {"properties"}),
#"Expanded properties" = Table.ExpandTableColumn(#"Expanded content1", "properties", {"http://schemas.microsoft.com/ado/2007/08/dataservices"}, {"properties"})
in
#"Expanded properties"
in
Source

Please help me how to fix this

[Anonymous]

Hi @Anonymous ,

Please refer to the following steps  and have a try.

It looks like youa re using Web.Contents and creating a dynamic url which is not supported by default to be refreshed on gateway, you will have to make some amendments in your report, here is the link that suggests the changes that can be made:

https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-...

Let me know if this doesn't help will share a more working example but in short you will have to make your url in 2 parts: Web.Contents("Base Address ", [RelativePath="the rest of api call parameters"])

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.