Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Expand all | Collapse all

Export Data out for Power BI

  • 1.  Export Data out for Power BI

    Posted Tue January 14, 2020 03:16 PM

    Hello 

    I am trying to export specific tables out of Apptio so that they can be used to create reports in Power BI. Please let us know how this is possible.

     

    Thanks in Advance.

    Dhivya


    #Platform


  • 2.  Re: Export Data out for Power BI

    Posted Tue January 14, 2020 06:15 PM

    Hi Dihvya - do you want to export a table from within the reporting view?  If so, just hover your mouse over the top of the table and right click to see the "Open in Excel" option.  Then you can save the table in Excel, csv, etc. for other purposes.  In the example below, I hovered right next to the name of the table to get the drop down (see attached From CT screenshot).  Conversely, if you have access to the TBM Studio, you can export individual tables by highlighting the name of the table in Project Explorer and then click on the Export icon from the Home ribbon (see attached From TBM Studio screenshot).

     

    Hope that helps!


    #Platform


  • 3.  Re: Export Data out for Power BI

    Posted Tue January 14, 2020 11:13 PM

    Use the API URL.


    #Platform


  • 4.  Re: Export Data out for Power BI

    Posted Wed January 15, 2020 02:40 AM

    The API URL option is available in the menu bar, see green box.


    #Platform


  • 5.  Re: Export Data out for Power BI

    Posted Wed January 15, 2020 03:30 PM

    Yep...API (Application Programming Interface).

     

    Take a look at this article to get started:

    Apptio Platform API 

     

    Some additional articles to review:

    Apptio APIs - Overview 

    Frontdoor API: cURL sample commands 

    Apptio API Demo Scripts 

    Power BI Direct API 


    #Platform