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 all,
I'm having some difficulties when attempting to paginate Log Analytics.
I've based my workings off of Power Query Pagination Example and have modified it to suit my needs/understanding.
I have the Token, GetCount functions working and I've modified other aspects which appear to work.
The main issue I'm having at present is using a variable that has other variables included. Power BI does not give the desired outcome, even though the input "appears" correct.
An excerpt below: -
let //Queries PaginationQuery = "{""query"": ""LogSource | where TimeGenerated > ago(30d) | sort by TimeGenerated asc nulls last | take " & Take & " | top " & Top & """}", //MiscVariables ResultsPerPage = 50, Take = Text.From(1 * ResultsPerPage), Top = Text.From(ResultsPerPage), //Format API call GetJson = let Options = [Content=Text.ToBinary(PaginationQuery), Headers=[Authorization="Bearer "&Token,#"Content-Type"="application/json"], RelativePath=DataRelativePath], RawData = Web.Contents(DataBaseURL, Options), Document = Json.Document(RawData) in Document, in GetJson
This results in a Bad Request message. Whereas if I simply replace the Query with: -
"{""query"": ""LogSource | where TimeGenerated > ago(5m) ""}"
It works as expected.
I've tried various ways of string/text manipulation but I get the same outcome.
Any ideas?
Solved! Go to Solution.
Some confusion over the query itself led to this problem.
E.g. take and limit are the same function (limit is an alias for take).
Top is seperate but uses additional parameters and effectively does the same as take/limit without having to do a seperate sort.
However they do not appear to work together to produce paginated results 😞
e.g.
Some confusion over the query itself led to this problem.
E.g. take and limit are the same function (limit is an alias for take).
Top is seperate but uses additional parameters and effectively does the same as take/limit without having to do a seperate sort.
However they do not appear to work together to produce paginated results 😞
e.g.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |