Need assistance on how do we integrate POWERBI with Commvault for custom reporting.
I can’t tell you WHEN it will be out, but his reply is in the thread above.
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
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
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 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
However, I am on the dataset rest api
How do I proceed from here?
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.