Forum Discussion
Real-time data ingestion from Adobe Analytics
Hi All,
Im trying to build a real-time data view of website traffic/conversions metrics and visualize it in PowerBI. The data source is Adobe Analytics, and i know we can connect to AA as a data source in powerbi but can't seem to find a way to configure Direct Query mode (streaming connection) from adobe analytics to for real-time automatic updates. Is it possible somehow in PowerBI Desktop or maybe in PowerBI Service?
Thanks
Shubham
10 Replies
- Greg_Deckler
Community Champion
Anonymous - I do not believe that the AA connector supports Direct Query. Direct Query support is per connector so some of them support it and some do not. Not aware of any way to get a streaming dataset from AA either.
- amitchandak
Super User
Anonymous , I doubt that with standard connector.
https://helpx.adobe.com/in/analytics/kb/integrate-adobe-analytics-with-power-bi.html
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-adobe-analytics
Explore some partner connectors. Just reference. Please check all details carefully.
https://www.cdata.com/kb/tech/adobeanalytics-powerbi-gateway.rst
bo_afkPost Patron
Hi Anonymous, did you manage to find a solution to this?
afk
- AnkitKukreja
Hi Anonymous
AA doesn't support direct query mode. Not sure if you would like to give schedule refresh a try to solve your issue.
You can schedule it every half hour if you're on premium capacity.Or you can try streaming live dataset option in service, not sure if it supports AA, but it worked on twitter for me.
Please go through the link below.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
Hope, it solve your issue.
Let me know if any other questions.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904- bo_afk
Hi AnkitKukreja, I'm on a PBI Pro account but not on premium capacity. I think my daily refresh limit is 8, am I correct?
Unfortunately this doesn't solve my issue if I'm looking for a real-time report using Adobe Analytics. Is there another solution?
Thanks
afk
- AnkitKukreja
Hi bo_afk
Can you try streaming live dataset option in service, not sure if it supports AA, but it worked on twitter for me.
Please go through the link below.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming Hope, it solve your issue. Let me know if any other questions
Thanks
Ankit
