Adobe analytics connector data refresh in on-premises gateway

[sushma_heggade]

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

[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.

[v-hashadapu]

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.

[Akash_Varuna · Accepted solution]

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