Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@LP2803 , check if this can help
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |