Integration with Power BI

ControlCenter can export data to Power BI using the web server.

Steps:

1. Configure the web server.
2. Create a new dashboard by logging into the web server as an administrator and adding a new dashboard.
3. For each data source you would like to export, create a table component and add it to the dashboard. Configure the tables fdl query to select your data.
4. After saving, right click on the table component and select csv.
Your browser now shows the raw data of the table.
5. In the browser url edit the file type of the url, replace .csv with either .telegraf or .headers.csv
6. These two formats will enable powerbi to import the data as a table.

The telegraf format

If you selected the telegraf format
Example url:

http://10.0.5.218:8080/dashboard/PowerBi/data/WP3ald2WYJ.telegraf

will produce a file like this:

[
	{
		"Job":"Database disk space usage",
		"Status":"WARNING",
		"Status time":"1775030813681",
		"Group":"Test",
		"Instance name":"NODE2 1433",
		"Details":"Drive F: 3.3 GB free space. 20 database(s) affected Ignored drives (no data files on that drive): C: 23.7 GB,",
	},
	{
		"Job":"Health state",
		"Status":"ALARM",
		"Status time":"1775030813769",
		"Group":"Test",
		"Instance name":"NODE2 1433",
		"Details":"Synchronization health on groupAGRP_GR is NOT_HEALTHY. 0  group(s) checked",
	},
	{
		"Job":"Agent Jobs Check",
		"Status":"WARNING",
		"Status time":"1775030813646",
		"Group":"Test",
		"Instance name":"NODE2 1433",
		"Details":"Failed jobs: [LSAlert_NODE2] at Apr  1 2026  3:30PM",
	},
	{
		"Job":"Instance memory check",
		"Status":"ALARM",
		"Status time":"1775030813687",
		"Group":"Test",
		"Instance name":"NODE2 1433",
		"Details":"The MS SQL Server instance is not able to allocate 60% of server memory (16 GB). 3168 MB (19% of total server memory) is allocated to the instance (Max server memory: 16383 MB,  Target memory: 3163 MB)",
	},
	{
		"Job":"Transaction log size check",
		"Status":"WARNING",
		"Status time":"1775030813651",
		"Group":"Test",
		"Instance name":"NODE2 1433",
		"Details":"dbwatch_1: 3608 MB log size which is 0% used (2560 MB data size, ratio log/data 141%), WideWorldImporters: 8736 MB log size which is 66% used (3072 MB data size, ratio log/data 284%),",
	},
	{
		"Job":"Database Log backup",
		"Status":"ALARM",
		"Status time":"1775030813803",
		"Group":"Test",
		"Instance name":"NODE2 1433",
		"Details":"No transaction log backup information for 1 database(s) (A_Works2016).",
	},
	{
		"Job":"Database backup",
		"Status":"ALARM",
		"Status time":"1775030813786",
		"Group":"Test",
		"Instance name":"NODE2 1433",
		"Details":"No backup information for 17 database(s) (WideWorldImporters, dbwatch, dbwatch_cc, dbw_kerb, dbw12, dbwatch_cc_demir4, dbw_kerb4, dbwatch_1, dbwatch_cc_1, dbwatch_cc_2).",
	}
]

The headers format

If you selected the headers format

example url:
bc. http://10.0.5.218:8080/dashboard/PowerBi/data/WP3ald2WYJ.headers.csv

Will produce a file like this:

Job,Status,Status time,Group,Instance name,Details
Health state,ALARM,1775030813769,Test,NODE2 1433,Synchronization health on groupAGRP_GR is NOT_HEALTHY. 0  group(s) checked
Agent Jobs Check,WARNING,1775030813646,Test,NODE2 1433,Failed jobs: [LSAlert_NODE2] at Apr  1 2026  3:30PM
Database backup,ALARM,1775030813786,Test,NODE2 1433,No backup information for 17 database(s) (WideWorldImporters, dbwatch, dbwatch_cc, dbw_kerb, dbw12, dbwatch_cc_demir4, dbw_kerb4, dbwatch_1, dbwatch_cc_1, dbwatch_cc_2).
Instance memory check,ALARM,1775030813687,Test,NODE2 1433,The MS SQL Server instance is not able to allocate 60% of server memory (16 GB). 3168 MB (19% of total server memory) is allocated to the instance (Max server memory: 16383 MB,  Target memory: 3163 MB)
Database Log backup,ALARM,1775030813803,Test,NODE2 1433,No transaction log backup information for 1 database(s) (A_Works2016).
Transaction log size check,WARNING,1775030813651,Test,NODE2 1433,dbwatch_1: 3608 MB log size which is 0% used (2560 MB data size, ratio log/data 141%), WideWorldImporters: 8736 MB log size which is 66% used (3072 MB data size, ratio log/data 284%),
Database disk space usage,WARNING,1775030813681,Test,NODE2 1433,Drive F: 3.3 GB free space. 20 database(s) affected Ignored drives (no data files on that drive): C: 23.7 GB,

Both formats are supported by Power BI, and it is more a matter of style.

The Power BI Gateway

Power BI has a tool named the Power BI Gateway that can be used to connect to url’s as on premise data sources and import data into Power BI.

Though it is possible to use the web server with an anonymous access token, it is recommended to generate a specific access token for the Power BI Gateway.
This can be used by providing a Authentication: bearer header with the token in the request.