Data in Adobe Analytics workspace does not match the data in Power BI Connector | Community
Skip to main content
A
anujajadhav2
August 5, 2022
Solved

Data in Adobe Analytics workspace does not match the data in Power BI Connector

  • August 5, 2022
  • 1 reply
  • 2612 views

Hi, 

 

I am connecting to Adobe Analytics using the connector in Power BI. I am bringing in following elements in Power BI just for one day - 1st Aug 2022.

1. Date Granularity

2. Visits

Then I created a table in Power BI as follows:

Day Visits
1 1234

 

To verify this single data point, I created a report in Adobe Analytics workspace expecting the total visits for this day to be exact same as what I am seeing in Power BI. Turns out the visits in Power BI are higher than I see in my workspace report.

Note: I have not used any segment in either of the reports making sure they are exactly same.

 

Can someone explain why this difference will be? Also has anyone fixed this issue where the data does not match within Power BI and Adobe Analytics workspace?

 

Regards,

Anuja

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by BrianTophamAdobe

There are a few differences in reporting between Workspace and Reports & Analytics, which is comparable to report API 1.4--which is what Power BI is currently based on. Most of the differences are based on the 'real-time' and 'lookback' concepts Workspace is able to do (and R&A/API 1.4 are not).

 

I don't generally expect default visits by day to be different between the two UIs however. It might not hurt to try the request in Reports & Analytics as well. Does it match Workspace or Power BI? Are you using the new beta version of Power BI (last I checked 2.0 version of Power BI is still in Beta)? I think those are the considerations I would make at the moment.

 

If the difference persists, you may want to open a ticket with support for a deeper dive. 

1 reply

BrianTophamAdobe
Adobe Employee
BrianTophamAdobeAdobe EmployeeAccepted solution
Adobe Employee
August 17, 2022

There are a few differences in reporting between Workspace and Reports & Analytics, which is comparable to report API 1.4--which is what Power BI is currently based on. Most of the differences are based on the 'real-time' and 'lookback' concepts Workspace is able to do (and R&A/API 1.4 are not).

 

I don't generally expect default visits by day to be different between the two UIs however. It might not hurt to try the request in Reports & Analytics as well. Does it match Workspace or Power BI? Are you using the new beta version of Power BI (last I checked 2.0 version of Power BI is still in Beta)? I think those are the considerations I would make at the moment.

 

If the difference persists, you may want to open a ticket with support for a deeper dive. 

    A
    anujajadhav2Author
    August 17, 2022

    Thank you for the response @briantophamadobe 

    I am using 1.0 version of Power BI, the 2.0 is still in Beta. The visits in workspace and Reports are an exact match. But they are still higher than what I see in Power BI. 

     

    I guess creating a support ticket is a way I can try.


    Regards,

    Anuja

      seanrobinson
      Adobe Employee
      seanrobinsonAdobe Employee
      Adobe Employee
      August 23, 2022

      If you need help creating a ticked, @nilotpal posted the steps a few days ago. Pasting the info here:

       

      You can raise a client care ticket through Admin Console provided you have Support Admin right in your Organization. 

       

      This can be done by logging in to Admin Console, Go to Support and Create a Case.

       

       

       

      Alternatively, you can ask the Support Admin in your Org to log a ticket on your behalf and add you as a watcher.

       

      You can also call on Adobe Support phone number and request help: https://helpx.adobe.com/entp/enterprise-phone-numbers.html. 

       

      Hope this is helpful. 

      Terms & ConditionsAccessibility statement

      Loading footer...