There are some differences between the data you receive through the Connector and the data you see in your Adobe Analytics workspace. | Community
Skip to main content
AhhyunHw
New Participant
February 27, 2025
Solved

There are some differences between the data you receive through the Connector and the data you see in your Adobe Analytics workspace.

Hi.
I want to receive Adobe Analytics data in Power Bi using Connector function.
However, there is some difference between the data received through Connector and the data I see in Adobe Analytics workspace.
Why is this difference happening?
I think it is because the timing of fetching data through Connector is not real-time. 
How does Connector fetch Adobe data? 
Why is there a difference?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
PoornimaThakur5
PoornimaThakur5Accepted solution
New Participant
February 27, 2025

The difference between Adobe Analytics data in Workspace and Power BI (via Connector) occurs due to data fetching timing, processing differences, and API limitations.

Workspace provides near real-time data, while Power BI pulls data via the Adobe Analytics API, which relies on cached datasets and may not reflect the latest events. Additionally, processing rules, attribution models, and segmentation in Workspace may not be fully replicated in API-based queries, causing discrepancies.

To reduce discrepancies, follow these steps:

  1. Match Segments & Metrics: Ensure that the same segments, calculated metrics, and attribution models are used in both Adobe Workspace and the API request in Power BI. Differences in definitions can cause variations in data.
  2. Check Data Refresh Timing: Power BI does not pull real-time data. Adjust the data refresh schedule to align with Adobe’s processing updates to minimize delays.
  3. Verify API Filters & Breakdown Selection: Ensure that the API request in Power BI applies the same dimensions, filters, and breakdown levels as in Adobe Workspace. Some filters may be ignored if not explicitly included in the API call.
  4. Use Data Feeds for Granular Data: If you need event-level accuracy, consider using Adobe Data Feeds instead of the API Connector, as the API aggregates data differently.
View reply

2 replies

PoornimaThakur5
PoornimaThakur5Accepted solution
New Participant
February 27, 2025

The difference between Adobe Analytics data in Workspace and Power BI (via Connector) occurs due to data fetching timing, processing differences, and API limitations.

Workspace provides near real-time data, while Power BI pulls data via the Adobe Analytics API, which relies on cached datasets and may not reflect the latest events. Additionally, processing rules, attribution models, and segmentation in Workspace may not be fully replicated in API-based queries, causing discrepancies.

To reduce discrepancies, follow these steps:

  1. Match Segments & Metrics: Ensure that the same segments, calculated metrics, and attribution models are used in both Adobe Workspace and the API request in Power BI. Differences in definitions can cause variations in data.
  2. Check Data Refresh Timing: Power BI does not pull real-time data. Adjust the data refresh schedule to align with Adobe’s processing updates to minimize delays.
  3. Verify API Filters & Breakdown Selection: Ensure that the API request in Power BI applies the same dimensions, filters, and breakdown levels as in Adobe Workspace. Some filters may be ignored if not explicitly included in the API call.
  4. Use Data Feeds for Granular Data: If you need event-level accuracy, consider using Adobe Data Feeds instead of the API Connector, as the API aggregates data differently.
Translate
Isha__Gupta
Isha__Gupta
Level 1
February 27, 2025

Hey @ahhyunhw ,

 

Your second screenshot has not uploaded, but I am assuming data in Adobe Analytics is lesser? Can you confirm if both tools are in same timezone settings as that could be one potential reason for data mismatch. You may look at below thread as that addresses issue similar to yours? 

 

https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/adobe-analytics-workspace-does-not-match-the-data-in-power-bi/m-p/580168

 

Best,

Isha

Translate
Terms & ConditionsAccessibility statement

Loading footer...