Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Making a Connection to Solarwinds from POWER BI

Does any one know how to create a connection to the solarwinds DB thru Power BI.

Find more posts tagged with

Accepted answers

Not specifically a Solarwinds question, but these two documents should give you what you need to learn. There is nothing particularly unique about connecting to Orion compared to any other MSSQL database.

Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Docs

SQL Server Analysis Services live data in Power BI - Power BI | Microsoft Docs

You would ideally want to have a separate user account for power BI to use, but to just test getting connected you could re-use the same account as your orion application uses to write to the db.

All comments

mesverrum

Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Docs

SQL Server Analysis Services live data in Power BI - Power BI | Microsoft Docs

You would ideally want to have a separate user account for power BI to use, but to just test getting connected you could re-use the same account as your orion application uses to write to the db.

martindillender

It would be good to be able to access via SWIS

mesverrum

I don't use powerbi enough to know if it can parse json natively, but if it knows how then there's really nothing to stop you from connecting to the API and pushing SWQL to it rather than direct SQL.