Has anyone had success with establishing direct API pulls into Power BI from Apptio R12? Our PBI team can pull successfully from R11 due to it being credential-based but we seem to be running into issues with the key-based authentication associated with R12 (and I've already verified that the keys are set up properly). Any guidance that I can pass along to the team would be greatly appreciated!

Andrew - we are trying to implement this as well. if you find the solution, would like to connect with you to understand better the success and challenges you had. 

I am also interested in this information, so following to see any helpful responses.

Hi @Andy Dawdy,

Unlike R11 which uses a single request response, R12 uses a two step process:

   1. Make a connection to frontdoor.apptio.com and get a "token"

   2. Use token to request data from your R12 instance

The beauty is that once you have the token, you can use it for subsequent calls. You can also choose to refresh the token before each call.

The only problem is that everytime the token is refreshed, you will need to update all your PowerBI queries with the token. I would look into whether this is possible through PowerBI API. I don't know PowerBI but this article might throw some light on using API to update PowerBI parameters: https://community.powerbi.com/t5/Developer/Updating-parameters-through-the-service-API/td-p/559439 

Hard coding your token is not a sustainable solution - so ask your team if they are able to set it up so that when you make a call, break it down into three steps:

1. Refresh Token and store it

2. Update BI Queries with updated token

3. Make API Calls

All the best!

Regards,

@Sanjay Valiyaveettil

Awesome tips. @Sanjay Valiyaveettil. No wonder you have a 'Ninja' avatar, .

@Pieter van Dam and @Lucas Wolters maybe interesting for us and the future.

this would be great if this feature will be available. 

Hi

 I have just started using Apptio and was wondering if someone could /had a step by step explanation of how you can connect to Power BI ?

Hi Aldo Angulo, post a link to your question as a status update to point folks to this thread - it will get you more traffic

I went on this rabbit hole path an learnt that Power BI & Apptio are competitors (of sorts), a few months back. We are trying to use REST to get the API to get the details in.