400 bad request

[pakot]

Hi,

I have following query in my pbix but when i try to close&apply changes I'm receiving bad 400 request:

let
Source = (VersionsRelevantSharePointListName as text, VersionsRelevantSharePointLocation as text, VersionsRelevantItemID as number) => let
Source = Xml.Tables(Web.Contents(
"https://xxx.sharepoint.com/sites/",
[RelativePath = 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

I guess I need to add something to web contents but I'm not sure what would that be.

Thank you in advance for help!

[Anonymous]

Hi @pakot 

This query is a function. Have you tried providing values for the three parameters and invoking it? Will this return the 400 error?

Best regards,

Jing

[pakot]

Hi,

in the PowerQuery I can invoke this function but the moment I'm trying to close PowerQuery and apply changes to my PowerBI I'm receiving bad request error. I'm also wondering if this could be related to the authorization/security level of the SharePoint page (?).