Forum Discussion

Venkat_Thota's avatar
Venkat_Thota
Frequent Visitor
2 years ago
Solved

Connect to Apptio from Power BI

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. 
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.