RESTful knowledge exchange
Post Reply
Champ14
Novice
Posts: 4
Liked: never
Joined: Mar 14, 2018 2:41 am
Full Name: Conrado Sambat
Contact:

How to connect PowerBI to Veeam Backup Ent Dashboard

Post by Champ14 » Mar 14, 2018 3:10 am

Hi,

I am new around here and not sure if I'm posting in the correct topic, if not please do let me know.

I am on the process of consolidating and automating ll our reports, one of the pending things I still need to add up is the Veeam BackUp Enterprise Status Report as shown in the Image below (Image1), I need to add this to my PowerBI report, but I'm not sure how to do it. I already tried the step to add the Dashboard Web URL to powerBI using the Option "Get Data>Web URL" but it is not getting any tables on it.

Image1: Veeam Enterprise Backup Manager - The details I want to be included in my PowerBI Report

Image

Thanks!!

benyoung
Service Provider
Posts: 87
Liked: 15 times
Joined: May 25, 2016 3:29 am
Full Name: Ben Young
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by benyoung » Mar 16, 2018 12:32 am

What are you specifically looking for - the high level job information in the 2 boxes? Total job runs etc?

There are a few reports exposed on /api/reports/summary endpoint if you query that

/reports/summary/overview provides general information about backup infrastructure components and performed backup and replication jobs.
/reports/summary/vms_overview provides information about backed up and replicated VMs, available restore points and so on.
/reports/summary/statistics provides information about performed jobs, their status, duration and so on.
/reports/summary/processed_vms provides information about processed VM on all Veeam backup servers connected to Veeam Backup Enterprise Manager.
/reports/summary/repository provides information about backup repositories.

Link to documentation here https://helpcenter.veeam.com/docs/backu ... tml?ver=95

Champ14
Novice
Posts: 4
Liked: never
Joined: Mar 14, 2018 2:41 am
Full Name: Conrado Sambat
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by Champ14 » Mar 16, 2018 2:32 am

Hi Benyoung,

Thanks for your response.. I already tried those links before but im getting the following error. Sorry forgot to mention that. We are using port 9443 to view the dashboard, when i use the link with the port 9443, im getting this error.

http://<Enterprise-Manager>:9443/api/reports/summary

Image

When using the port 9398 for https im getting this error

Image

Can you let me know if there's a pre-requisite procudure I need to do before I can link it to that URL? Or it is really a straighforward link?

Thank you

benyoung
Service Provider
Posts: 87
Liked: 15 times
Joined: May 25, 2016 3:29 am
Full Name: Ben Young
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by benyoung » Mar 16, 2018 2:49 am

Hey Champ

You cant just consume these via your browser/pulling down the content from that URL unless you use that webclient version which I have never looked at other that seeing the page in the documentation, plus these all (including the API endpoints) run on different ports to the Enterprise Manager website

you will need to create a session with the sessionmanager first, then pass the authentication header in your requests

Typical workflow for using the API here (note the urls/ports for the API)

https://helpcenter.veeam.com/docs/backu ... tml?ver=95

You can authenticate easily using process here (essentially posting using a basic http auth header to the session manager endpoint)

https://helpcenter.veeam.com/docs/backu ... tml?ver=95

Once your authenticated you'll see a list of available URLs available under your version/roles etc - use the X-RestSvcSessionID that is returned via sessionmanager post above for future requests passing this as a header to the API

Then you can call (http get) the URLs such as (remember to pass the X-RestSvcSessionID header)


http://<Enterprise-Manager>:9399/api/reports/summary
http://<Enterprise-Manager>:9399/api/reports/summary/overview
http://<Enterprise-Manager>:9399/api/reports/summary/vms_overview
http://<Enterprise-Manager>:9399/api/reports/summary/job_statistics
etc

Champ14
Novice
Posts: 4
Liked: never
Joined: Mar 14, 2018 2:41 am
Full Name: Conrado Sambat
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by Champ14 » Mar 16, 2018 4:12 am

Hi Benyoung,

The post you are giving is very helpful...

Now, I want to know how to create a session with session manager? then how to pass the authentication header? Im sorry im really a noob to this thing. :(

v.eremin
Product Manager
Posts: 16232
Liked: 1325 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by v.eremin » Mar 16, 2018 5:48 pm

Now, I want to know how to create a session with session manager? then how to pass the authentication header? Im sorry im really a noob to this thing. :(
Conrado, I'd recommend you checking the referenced User Guide first before doing any coding. More specifically, this example. Thanks.

Champ14
Novice
Posts: 4
Liked: never
Joined: Mar 14, 2018 2:41 am
Full Name: Conrado Sambat
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by Champ14 » Mar 19, 2018 2:10 am

Hi v.Eremin,

I already read that site, and honestly I cannot understand how it can be done. I think the solution is the creation of session in session manager mentioned by Benyoung but I dont know how to do it.

benyoung
Service Provider
Posts: 87
Liked: 15 times
Joined: May 25, 2016 3:29 am
Full Name: Ben Young
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by benyoung » Mar 19, 2018 7:31 pm 1 person likes this post

Hi Champ

If you are trying to use this just in your browser - this will not work. It is designed to be called programmatically via a script/program. You will need something that can deal with basic HTTP requests such as GET and POST for the most part if you are only looking to get information out of the API

This page here explains how what is needed to HTTP POST to the session manager endpoint to get the session token (basically a combination of an admin username/password) posted to the endpoint

https://helpcenter.veeam.com/docs/backu ... tml?ver=95

You will be returned back the session identifier which needs to be set on any other requests as an HTTP Header to the API such as HTTP GET request to the reporting

I suggest so you can get a feel for how this works look at a program called Postman, it is an app you can easily check out APIs and run tests etc you can then point it at the Session Manager endpoint and Postman even has some boxes for you to enter your username and password into which will do the credential joining portion as referenced in the documentation, look at is what is returned in Postman, as referenced in the docs you will see a list of available URLS in the response body and in the response headers you will see the sessionID

From there you can start to play around with the other api endpoints like the reporting ones you are after

Hope that helps

Cragdoo
Veeam Vanguard
Posts: 515
Liked: 204 times
Joined: Sep 27, 2011 12:17 pm
Full Name: Craig Dalrymple
Location: Scotland
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by Cragdoo » Mar 29, 2018 10:40 am 1 person likes this post

I've started to look into the potential for using PowerBI in conjunction with Veeam REST APIs and I can tell you it isn't easy to setup ...and it appears to be more a PowerBI issue (limited config for handling tokens etc)

mikeconjoice
Veeam Vanguard
Posts: 7
Liked: 1 time
Joined: May 09, 2016 3:59 pm
Full Name: Mike Conjoice
Location: UK
Contact:

Re: How to connect PowerBI to Veeam Backup Ent Dashboard

Post by mikeconjoice » Jun 05, 2018 10:49 am

Cragdoo wrote:I've started to look into the potential for using PowerBI in conjunction with Veeam REST APIs and I can tell you it isn't easy to setup ...and it appears to be more a PowerBI issue (limited config for handling tokens etc)
Echo Craig's comment here. It hasn't been easy so far; I've resorted to running our dashboard through SQL queries to the VeeamDB which isn't ideal

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests