connect Adobe Analytics API to Power BI

[Anonymous]

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.

[ReportMaster]

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

[Anonymous]

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!