PowerBI to Commvault Integration

Hi @Pratik Chaudhari !  Thanks for the thread.

After reading your pm, I remembered that we had a topic for this, and got some good responses from our reporting documentation master:

The short version is that we mostly have access to the database locked down, but you can use APIs to get the data (and the how-to is covered in the above thread).

Take a look and let me know if you have any questions.

I’m going to resurrect this for selfish purposes. 

I am attempting to use commvault report data to import to powerbi and the question I have is what Key should I use?

Is there a way to generate a semi-permanent api key so I can do refreshes against the report dataset?

Essentially I am making environmental changes and if I can get this work, I can get close to real time updates on the progress of the changes I am making.

Thanks.

Chris.

@christopherlecky , I found the thread this was discussed (and answered by dev):

I can’t tell you WHEN it will be out, but his reply is in the thread above.

Awesome, I will see what I need to do to track it.

@Pratik Chaudhari ,

I now understand the issue that you are running into. 

The important thing to understand is that what is being returned by the rest api is a dataset.

You then have to parse the dataset in Powerbi

I have to do the same thing, once I figure it out I will make a howto post.

In the interim you may find this useful 

Thanks.

Chris.

Before 5 years when such requirement came to me, I just added the Power BI user ID to Commvault’s DB security logins. Created the required report template in BI and it started populating those reports that are required

@Ramkumar Giridaran Can you please elaborate steps to achieve this? 

@Ramkumar Giridaran Please do provide steps on how to go about integration to commvault?

@Uchenna Upgrade Commserve to 11.30 (2023) and use rest api datasets to connect with Commvault reports using AuthToken

@SGMak thank you for your feedback.

However, I am on the dataset rest api
How do I proceed from here?

@Uchenna 

Please follow the BOL:

Datasets:

https://documentation.commvault.com/2023/essential/115048_rest_apis_for_reports.html

Create Acceess token: https://documentation.commvault.com/2023/essential/153488_access_tokens_for_rest_apis_01.html