Need VeeamONE SQL DB tables info to create custom Power BI backup dashboard

[NK100251]

Hi Team,

I want to create a Power BI dashboard for backup which requires connecting with SQL server database for Veeam backup server.

Instead of using multiple backup servers SQL DB, I think it would be better if we can use VeeamONE SQL Database which has all information available.

I am able to connect VeeamONE SQL DB in Power BI successfully.

In order to create reports for backup I need information which tables should I select to create my reports in Power BI.

I would need info on only selected tables/schema under SQL DB on Veeam ONE which has info about server backup status and backup servers, backup jobs overview in last 24 hours and in 7 days, average backup speed, backup windows etc.

I tried to connect with Veeam support but they couldn't provide the info.

I am looking forward to your help.

[RomanK]

Hello Neha

Often there is no raw data you requested, multiple tables are used and additional operations would be required to process the data. Moreover, we cannot guarantee that there will be no changes in the database tables in the future.

Did you check the REST API instead? At a glance, it seems to me everything should be there and it is a more reliable way to get the data.

Thanks

[jorgedlcruz]

Hello Neha,
As Roman pointed out, checking the DB directly is not supported officially, meaning that we can not point you to tables or queries that might change in the future, plus imagine for some reason some data is truncated in the process. It will work of course, and if I was investigating by my own I would probably look at the SQL store procedures that most likely have all the data in the format PowerBI or other tools can consume. But that, again, is flying solo and without official support.

Now, officially we exposed API endpoints to satisfy these scenarios.

Here is the map in case you want to take a look:
https://www.veeam.com/veeam_one_12_0_re ... map_ot.pdf

For example:
1. Backup job status - We have endpoints under vbrJobs

We are always happy to get feature requests to improve our API, so we would encourage you to take a look and share what is missing if possible.

Thank you

[NK100251]

Thanks jorgedlcruz for providing some insights.. I don't think Power BI uses REST APIs as dataset to create dashboards. Do you happen to know process to get these REST APIs in Power BI?

You mentioned, SQL store procedures that most likely have all the data in the format PowerBI or other tools can consume. I am not sure how we can use it? Can you provide some info?

[NK100251]

In addition to this, Can you provide the info on how to get details from SQL DB tables for total space vs free space?

[NK100251]

I tried using the VEEAM ONE REST APIs in Power BI via Get Data-->Web, seems like the access token requires authorization header option in the power BI API call option. However, options available are Accept,Accept-Charset,Accept-Encoding,Accept Language,Cache-Control,Content-Type,If-Modified-Since,Prefer,Range,Referer

Not sure which option to choose from as Veeam support is unable to provide this answer. Veeam Support - Case # 07003348

I also tried to use the service account which has full permissions/rights to access Veeam ONE web client & REST APIs but it didn't authenticate.

[nielsengelen]

Hi,

You could have a look at this VB365 example blogpost which you can probably alter to VONE settings.

[NK100251]

@nielsengelen
This is blog is using SQL server for VBR server which I have tried already but like product team recommends not to use SQL server tables as schema always changes with new version release.

I have already created Power BI using this but it is valid until SQL schema/tables remain same or not changed.

By the way, in this blog I see there is one chart created from Backup Repositories tables i.e. Free Space vs Total Space.

I don't see this option in Backup repo tables under SQL server.

[nielsengelen]

Hi Neha,

Sorry, I meant to reference to the article on VB365 with PowerBI. I have probably copied the link from the wrong tab being fast.

[NK100251]

@nielsengelen : I read your article mentioned. Here HTTP Request Header option is used as "authorization" but in Power BI new version, this option is not available.