Power BI / Excel data from Rational Concert
Hi,
We use Rational Quality Manager at my workplace and are looking to get reports and queries directly in Excel or Power BI using the live data connection.
I am trying to get this data using the current report link: https://qualitymanager.company.com/qm/web/console/Module#action=com.ibm.rqm.planning.home.actionDispatcher&subAction=viewReport&name=NAME&queryUUID=xxx&shared=false
Unfortunately trying to use this in Excel OR Power BI leads me to just get back the login screen for Rational.
Does anyone know how to actually get data to return using this method? I have tried some other forum post answers but they don't allow me to get data just the login screen.
One answer
PowerBI is a fiddly thing to integrate with.
I've helped several clients do it as the 'ELM expert', not the PowerBI expert - the main issue appears to be that the connection can only be done in the PowerBI client because you have to set up an authenticated connection, and OAuth2 (or any of the other approaches supported by ELM) in PowerBI is only available as a custom connector, which apparently is only available in the client?
This means that data can only be pulled into PowerBI as a manual process via the desktop, and so most of my clients ended up creating a Report Builder report and saving it as a live Excel spreadsheet, then setting up PowerBI to suck the spreadsheet in.
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 19 '24, 10:53 a.m.Except the rootservices document, you can not access anything on a Jazz Server without being authenticated. It is simply impossible. It would be necessary to understand how to authenticate. I believe you can export JRS reports to Excel and look how that authentication works.
One form of authentication is explained here: https://rsjazz.wordpress.com/2021/10/15/elm-authentication/ OAuth is also a way that could be used.