Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

What options are available to pull data from Aha! roadmap software into Power BI

I have done some initial research and did not find any Aha! connectors.  We are looking to incorporate some roadmap/feature data with data pulled from other systems.

 

I understand Aha has a Rest API for obtaining data, but from what I've read that will require some coding and familiarity with API than my current skillset.  Does anyone have another option for consuming the data into Power BI?

 

Thanks,

Phil

  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    I'd like to suggest you use web connector with official Rest API of your data source: (this require you familiar with power query web connector and know how to add optional parameters and headers and authorizations)

    Aha! REST API 

    Connecting PowerBI Web Service to a REST API - possible? 

    If you not familiar with these, you can consider 'export data source as local file' then use power bi file connectors to get data.

    Regards,

    Xiaoxin Sheng

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Depends, if the REST API brings back CSV, XML, OData or JSON, shouldn't really take much coding.

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous,

    I'd like to suggest you use web connector with official Rest API of your data source: (this require you familiar with power query web connector and know how to add optional parameters and headers and authorizations)

    Aha! REST API 

    Connecting PowerBI Web Service to a REST API - possible? 

    If you not familiar with these, you can consider 'export data source as local file' then use power bi file connectors to get data.

    Regards,

    Xiaoxin Sheng