Welcome to the Jazz Community Forum
How to Integrate IBM Rational Team Concert and Power bi tool
2 answers
I have heard of organizations doing this; I haven't done it myself.
One way would be to make data from specific Jazz Reporting Service Report Builder reports available to PowerBI. When you export a JRS report to Excel, you can get a link to "live" data. I believe you can use this link in PowerBI as well.
Add to an existing spreadsheet
-
Copy this URL:
https://<your jrs server>/rs/query/<your report number>/dataservice?report=<your report number> - In the workbook, click Data > From Web.
- Paste the URL into the Address field.
- Log in with your Jazz Platform credentials.
Get the Live data option on your toolbar
If you are using Excel in office 365 or latter, you can easily add this live data option to the toolbar:
- Click File > Options and select Customize the Ribbon.
- In the Choose commands from: section, select Main tabs.
- Expand Data > Get External Data > From web.
- In the Customize the Ribbon: list on the right side, select Main tabs > Data.
- Click the New Group button to create a custom group. Rename it to Live data.
-
Click Add>> and then click Ok.
Now you can see the Data > From web (Live data) option on the toolbar.
This doesn't seem to work for me. Has anyone been able to get a working solution for viewing reports / query data in Excel & Power BI? Thanks
Comments
Hi, If you want anyone to look at your question, create a new question. You can reference to the existing one using a link.
Your comment cited below, is insufficient. If a step in the answer above does not work, mention this.
Also note, I doubt we have a lot of PowerBI experts here. We have different reporting solutions. There are some integrations with Excel, which is a different matter. I think they were mentioned, because you could get links to access data using the links.
"This doesn't seem to work for me."