Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to automate PowerBI data pulls from Adobe Analytics

Hi, I am trying to automate my report to pull data from Adobe analytics but I am asked to specify a date range. Not sure if there is a way to automate the data pull or a roundabout solution for this...
ReportGuru's avatar
ReportGuru
Icon for Post Patron rankPost Patron
2 years ago

Hi Anonymous As a workaround, maybe you can test your connection with a 3rd party connector.  I use Windsor.ai Adobe connector and before exporting to PBI I can select the date range, so then my report will always keep updated with the lastest data. 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