Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

TheScottR24
Community profile TheScottR24 Level 1
Job title here
Location here
2 BADGES
Level 1

Level 1

Learn more
Joined the community 12-08-2020 6:30:54 AM
Offline
Top badges earned by TheScottR24
Customize the badges you want to showcase on your profile
Re: PowerBI connector - unique visitors aggregation issue
Avatar
Give Back
Level 1
TheScottR24
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
TheScottR24
- Adobe Analytics
Hi @kainth, Thank you for the reply. I think the main problem as I mentioned in my post is the aggregation of the unique visitor numbers as it is pulled into PowerBI. We used to have an export set up that pulled the data from Data Warehouse and was loaded onto a SQL database. That data contained a field called Unique Visitor Identifier which could be used in tools like Tableau or PowerBI to do Count Distinct functions, which provided accurate unique visitor numbers for whatever date granularity ...

Views

251

Likes

0

Replies

0
PowerBI connector - unique visitors aggregation issue
Avatar
Give Back
Level 1
TheScottR24
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
TheScottR24
- Adobe Analytics
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 Po...

Views

279

Likes

0

Replies

2