What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

Reports into Power BI via API?

Votes:

0

Hi all, I hope you can help.

We currently are in the process of creatinga dashboard in PowerBI, ultimately we want to display one live chart for critical servers sensors and a seperate chart to show uptime for critical servers daily, this month, last month, and year to date.

We have been able to create a live chart for the critical servers by using the API . However, using the API to call on many sensors for a specific range seems to drag the system to a hault.

Is there an easy way to esentially export our current reports via API directly into PowerBI? Or would it be easier to save the specific date reports to a CSV and then import that way?

Many thanks

api powerbi report

Created on Feb 13, 2019 5:01:48 PM



1 Reply

Votes:

0

Note: The SLA Plugin from Corp IT has been deprecated. If you would like to explore enhanced SLA reporting options, check out the PRTG SLA Reporter, a PRTG extension. A free trial is available from the Paessler website.

The PRTG SLA Plugin by CORP-IT (one of our partners) allows you to put the historic data into a MSSQL, allowing you to integrate it into your PowerBI environment :)

Other than that, you could also use PRTGapi to export the data via a scheduled task. Note that historic data is limited to five queries per minute for performance reasons.

PRTGapi | Feature Requests | WMI Issues | SNMP Issues

Kind regards,
Stephan Linke, Tech Support Team

Created on Feb 14, 2019 12:26:46 PM by Stephan Linke [Paessler Support]

Last change on Feb 1, 2024 5:20:32 PM by Jacqueline Conforti [Paessler Support]




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.