Solarwinds SWQL Query Connection with PowerBI Dashboard

Question

Hi Everyone,

I need to connect the SWQL which is created in my SWQL Studio with the PowerBI dashboard so that it show all of the alerts which are there in my report should be visible on the PowerBI,

Please let me know the process how can i customize it.

Thanks

vinay.by · Answer

Hi @VaishuT

I have seen a few different integrations as well in the past where the environments were pretty big, one of the methods that was used is as mentioned below:

SolarWinds ← Azure Datalake ← PowerBI

Search for the following if you have a similar environment and you would easily find the required details to setup the same:

* Pull SolarWinds data via its API and store it in Azure Data Lake Storage Gen2
* Connect azure data lake storage gen2 to power bi

Hope this helps.

stuartd · Answer

If I understand, you want to connect PowerBI to Solarwinds.

A quick web search gives me this:

Failing that, a search of prior posts in THWACK might help:

In no particular order try:

https://thwack.solarwinds.com/discussion/152340/detailed-how-to-connect-solarwinds-to-powerbi-to-create-dashboards-for-reporting

or

https://thwack.solarwinds.com/discussion/98427/enabled-alerts-report-for-prior-week-for-powerbi