Forum Discussion
Adobe analytics connector data refresh in on-premises gateway
Hi,
We have a adobe analytics data source for one of our PBI report, But upon checking we can schedule the refresh on onpremises gateway.
So, we are manually refreshing the data source daily, to avoid this we are planning to automate this process.
It really helps if you can suggest someway to achieve it.
Thanks in advance
Hi sushma_heggade To automate Adobe Analytics data refresh you could use Dataflow or adf please check these
On-premises gateway does not support Adobe Analytics. Instead, use a cloud-based dataflow in Power BI to connect directly.
Leverage Adobe Analytics API to pull data into Azure Storage or SQL Database, and connect Power BI to this intermediate source.
For Automating use Azure Data Factory or a similar tool to schedule the API data extraction and refresh the source.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
4 Replies
- Akash_Varuna
Super User
Hi sushma_heggade To automate Adobe Analytics data refresh you could use Dataflow or adf please check these
On-premises gateway does not support Adobe Analytics. Instead, use a cloud-based dataflow in Power BI to connect directly.
Leverage Adobe Analytics API to pull data into Azure Storage or SQL Database, and connect Power BI to this intermediate source.
For Automating use Azure Data Factory or a similar tool to schedule the API data extraction and refresh the source.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance 
v-hashadapuCommunity Support
Hi sushma_heggade , Thank you for reaching out to the Microsoft Community Forum.
Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.- v-hashadapu
Hi sushma_heggade , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you. - v-hashadapu
Hi @sushma_heggade , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.