Forum Discussion
400 bad request
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!
2 Replies
- AnonymousNot applicable
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
- pakotFrequent Visitor
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 (?).