Hi,
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?