Commvault Cloud SaaS 365 and PowerBI


Badge +1

Hello,

 

I want to use PowerBI to retrieve data from Commvault Cloud SaaS plateform but even after reading the documentation from API portal and tried to connect to the URL with a specific user I didn’t make it work.

Does anyone already use a custom query into PowerBI to get access to Commvault platform through API ?

I don’t need help about transforming the data but just to understand how to connect to the API it seems that there is no token, I need to use a username and password to my metallic.io URL but it’s unfortunately not clear.

 

Thanks for your help.

 

Benjamin


4 replies

Userlevel 3
Badge +10

@BRupp 

Please use the below DOC and select the SaaS option in the DOC. Create the QSDK token using your tenant admin ID and run the other APIs.

https://api.commvault.com/docs/SP34/api/cv/AuthenticationOperations/login

URL, Header and body information should be correct.

Badge +1

Many thanks for your quick answer.

 

If I give a try with “Send API request” i get the result below.

 

Is it correct to use the UPN as the user ?

Userlevel 3
Badge +10

@BRupp 

Use the email with a base 64 encoded password and then try to create the token.

Badge +1

@Navneet Singh 

Many thanks for your help, i was misunderstanding the part related to the encoded password.

I have a report that is working now that I can use to retrieve last backup status for all my customers because we’re not MSP and have separate account for each customer. Using email report is too headache.

Really basic but useful for my need:

 

Reply