I am newly using PowerBI to connect to my Adobe Analytics website data and while pulling some basic data (unique visitors, visits, page views with one dimension called site section) from AA I noticed big differences in the unique visitor numbers that I get in PowerBI versus what I see within my AA workspace reporting. After investigating, I believe it may have to do with aggregation of the unique visitor numbers because if I remove the Date Granularity fields from the data being loaded to PowerBI, the total values I am getting are correct, but if I include the Date Granularity fields the total values are incorrect. Also interestingly, if I use a line chart to show trend of unique visitors by site section, if I look at it from a monthly level it is also wrong, but if I drill down to daily values then it is correct / matches AA workspace.
The problem is that I need the date fields for my reporting to be able to show the data by year, month, etc., so is there any way to have accurate unique visitor numbers with the date granularity?
Based on my understanding, the unique visitor number can vary in Analysis Workspace & Power BI due to the following reasons.
1. Due to segments, if you have currently applied any segment then I would request you to try to compare the number by removing the segments. 2. Analysis Workspace & Power BI both use different Analytics API version. Analysis Workspace is based on Analytics API 2.0 whereas the Power BI integration uses the Analytics API 1.4. If you need to compare the Power BI numbers with Analytics then my suggestion will be to try comparing these numbers in either Reports section of Analytics user interface or try creating a similar request in Adobe Report Builder to see if the number matches because Reports section of Analytics & Report Builder are both based on Analytics API 1.4.
Hope this helps. In case even after trying the above suggestion, you notice any discrepancies then I will suggest you to log this issue with the Client Care team. So, that we can investigate further on the issue if needed.