Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Team,
I have a problem with API call from passing data from one query to another through parameter.
Query1:
let
Source = Json.Document(Web.Contents("https://api.onguard.convergeone.com:8080/cc2076video/videoCDR/_search?q=@timestamp%3A[2019-10-01T00:...")),
hits = Source[hits],
hits1 = hits[hits],
#"Converted to Table" = Table.FromList(hits1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"_index", "_type", "_id", "_score", "_source"}, {"Column1._index", "Column1._type", "Column1._id", "Column1._score", "Column1._source"}),
#"Expanded Column1._source" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1._source", {"@timestamp"}, {"Column1._source.@timestamp"}),
#"Sorted Rows" = Table.Sort(#"Expanded Column1._source",{{"Column1._source.@timestamp", Order.Descending}})
in
#"Sorted Rows"
Query2:
let
Source1 = Json.Document(Web.Contents("https://api.onguard.convergeone.com:8080/cc2076video/videoCDR/_search?q=@timestamp%3A[2019-10-01T00:...")),
Source = Json.Document(Web.Contents("https://api.onguard.convergeone.com:8080/cc2076video/videoCDR/_search?q=@timestamp%3A["& Parameter1 &"%20TO%20now/d]&size=10000")),
hits = Source[hits],
hits1 = hits[hits],
#"Converted to Table" = Table.FromList(hits1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"_index", "_type", "_id", "_score", "_source"}, {"Column1._index", "Column1._type", "Column1._id", "Column1._score", "Column1._source"}),
#"Expanded Column1._source" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1._source", {"@timestamp"}, {"Column1._source.@timestamp"}),
#"Sorted Rows" = Table.Sort(#"Expanded Column1._source",{{"Column1._source.@timestamp", Order.Ascending}})
in
#"Sorted Rows"
Hi @LP2803 ,
I'm not good at Power Query. There's an official document about this error and that's all I found. Hope it works for you.
https://docs.microsoft.com/en-us/power-query/dataprivacyfirewall
Best Regards,
Jay
@amitchandak Thansk for the reply.
But i have already read many posts including this but not able to resolve the issue.
Kindly help me.
Can someone help me with this please.. why im having error even when i reference the original Query(1) in Query2