Need assistance on how do we integrate POWERBI with Commvault for custom reporting.
Hi
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.
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.
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
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
However, I am on the dataset rest api
How do I proceed from here?
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.