New Question

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

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

Your Vote:

Up

Down

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 by fr3t (0) ●1



1 Reply

Votes:

0

Your Vote:

Up

Down

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]



Please log in or register to enter your reply.


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.