Connect to Apptio from Power BI

[Venkat_Thota]

Hi,

how to connect to Apptio data from Power BI. any connect available or have to use REST API? 

Unfortunately I cant find much documents on internet. any leads to that is really helpful. 

[v-jtian-msft · Accepted solution]

Hi,@Venkat_Thota . I am glad to help you.
Hello,@rajendraongole1,thanks for your concern about this issue.

Your answer is excellent!

Unfortunately ,I can't find anything at the moment about a connector for power BI to connect to Apptio.
As @rajendraongole1  suggests, using RestAPI for data fetching is a very good solution

Here I would like to share some additional solutions below.
If you need to make a good report to publish to a service and do a refresh operation
I suggest you to use RestAPI+dataflow method.
Create a dataflow, and configure the API data source, then publish the dataflow to the service, you can use the created dataflow as a processed data source。 And for the report data refresh, you can configure the dataflow refresh schedule to achieve. By combining them, you can avoid the situation that the report made by the data source obtained from API cannot realize the gateway connection on the service directly.

URL:
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Creating a dataflow - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Venkat_Thota]

@v-jtian-msft ....okay it make sense. thank you. 

[rajendraongole1]

Hi @Venkat_Thota -Check with your Apptio administrator or documentation to ensure that Apptio provides an API and you have access to it.Obtain the API endpoint URL, necessary credentials (e.g., API key, username, password), and understand the API request format.

Please check the below resolved and reference link

Azure Marketplace | Microsoft Azure

.Solved: Connection between Apptio and PowerBI - Microsoft Fabric Community

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Venkat_Thota]

Thank you Rajendra for your reply.