Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

connect Adobe Analytics API to Power BI

Hi,

We are trying to connect to Adobe Analytics API by Power BI, trying to create a power bi query for getting some data.

Could anyone give me some suggestions how can i implement something like this?

Thanks.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

     

    You may first try the Adobe Analytics connector which is built on the Adobe Analytics APIs. 

    Power Query Adobe Analytics connector - Power Query | Microsoft Learn

     

    If this connector cannot give you the data you want, you can try using Power Query's Web.contents function to send Get/Post requests to the APIs for querying the data. 

    Web.Contents - PowerQuery M | Microsoft Learn

    Getting Started with API's in Power Query • My Online Training Hub

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

  • Hi Anonymous were you able to find a solution? As a workaround, maybe you could try connecting your Adobe data throught a 3rd party connector. I currently use windsor.ai's Adobe connector and it works fine, so just to let you know other options. In case you wonder,  to make the connection first search for the Adobe connector in the data sources list:

     

     

    Then, you should enter your Adobe credentials to make the connection. After that, you'll see a preview of your data where you can select the fields you want to see in PBI. 

     

     

    Finally, you just have to choose PBI as destination and copy and paste the url that will appear there in PBI desktop --> Get Data --Web > --> Paste the link