Forum Discussion

Patrick Naughton's avatar
Patrick Naughton
Brass Contributor
Sep 26, 2018

PowerBI calls Log Analytics via query string, fails on large queries.

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 que...
Azure Log Analytics
azure monitor
Patrick Naughton's avatar
Patrick Naughton
Brass Contributor
Oct 04, 2018

I know urls are 2k, that was why i posted.

 

also, post does not work with authenticated queries.

 

https://social.technet.microsoft.com/Forums/en-US/6366dd5d-302c-42fb-8283-c833954c3858/sending-contents-to-windows-authenticated-service-results-in-an-error-quotcontent-option-is-only?forum=powerquery

 

 

Jason Dempsey's avatar
Jason Dempsey
Copper Contributor
Oct 04, 2018

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.

  • ScottAllison's avatar
    ScottAllison
    Iron Contributor
    Oct 05, 2018

    Ultimately, Power BI should have DirectQuery functionality with Log Analytics (like the new Grafana plugin).