Sep 26 2018
03:07 PM
- last edited on
Apr 07 2022
05:30 PM
by
TechCommunityAP
Sep 26 2018
03:07 PM
- last edited on
Apr 07 2022
05:30 PM
by
TechCommunityAP
It seems that PowerBI only talks to Log Analytics via an url encoded query string.
https://api.loganalytics.io/v1/workspaces/workspaceid/query?query=your url encoded query here...
If your query is large, this will get cut off after 2KB... and fail.
Is there any way to make PowerBI POST the query rather than putting it on the URL?
Oct 04 2018 11:51 AM
If you are talking about the length of the query string, URIs are often limited to around 2k as I recall.
https://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers
Were you looking for how to make PowerBI do this through POST or how to POST to AzureLogAnalytics? As I recall, both are possible:
PowerBI Post:
https://blog.crossjoin.co.uk/2014/04/19/web-services-and-post-requests-in-power-query/
Azure Log Analytics:
https://dev.loganalytics.io/
Oct 04 2018 11:57 AM
I know urls are 2k, that was why i posted.
also, post does not work with authenticated queries.
Oct 04 2018 12:22 PM
That sounds like a better question for the PowerBI forums, as PowerBI can do POST (but apparently not authenticated POST), and Azure Log Analytics uses authenticated POST.
After a cursory look at PowerBI's data sources, it looks like Azure Log Analytics isn't currently a supported data source for Power BI. You could probably get around this by either writing a PowerShell script and storing the responses locally, or you could write a Power BI custom connector.
Oct 05 2018 05:26 AM
Ultimately, Power BI should have DirectQuery functionality with Log Analytics (like the new Grafana plugin).