I am attempting to pull in endpoint/incident data using the appropriate API in PowerBI. However, there's a limit of 100 . I tried adding a separate custom column anticipated that my total number of incidents would be let's say "x" value, but that just repeats the already pulled 100 rows. See a copy of the Query I am using below: let body = "{ ""request_data"": {}}", GetJson = Web.Contents("[URL_GOES_HERE].xdr.us.paloaltonetworks.com/public_api/v1/incidents/get_incidents/", [ Headers = [#"Content-Type" = "application/json", #"x-xdr-auth-id" = "[Auth_ID_GOES_HERE]", #"Authorization" = "API_Key_GOES_HERE" ], Content = Text.ToBinary(body) ] ), FormatAsJson = Json.Document(GetJson), #"Converted to Table" = Record.ToTable(FormatAsJson), Value = #"Converted to Table"{0}[Value], Incidents = Value[incidents], Result = Table.FromRecords(Incidents), #"Changed Type" = Table.TransformColumnTypes(Result,{{"creation_time", Int16.Type}}) in #"Changed Type" Any help in correcting my logic will be greatly appreciated
... View more