Best way to get Unique Visitors in PBI Connector

[AtindraBa]

I am trying to get unique visitors data from PBI connector. The problem is the data is correct only at the granualarity at which the data is being pulled (say daily). If I sum it up at the monthly level it leads to a lot of duplicates. What is the best way to get this data from PBI connector. Getting data at visitor id level could be too much? 

[Pablo_Childe · Accepted solution]

Hi so that UV issue you face is a typical challenge as the metric has that de duplication done y Adobe in its back end.

Ideally instead of trying to do that ton of post processing yours self. I recommend you do multiple queries your self in PBI.

So lets you want daily totals, 
do a query for daily, then do a query for monthly.(then if you need yearly) do a 3rd for yearly.
GLTU

[Jennifer_Dungan]

I agree with this...if you are trying to pull out essentially "processed data", then you need to pull a call for granularity you want the content de-duplicated for. I've done the same in Report Builder reports where I need granular data (say by day) and I need the total for the month... For PVs I can just add them up (unless I am looking at list info), but for Visits or Unique Visitors (metrics that need deduplication), I make a call for each granularity.