Forum Discussion
Google Analytics # users vs # users PowerBI
Here is an explaination AND a potential solution
The solution outlined makes everything a little more complicated (you'll have to create a DAILY fact, a WEEKLY fact, a MONTHLY fact etc.) *and* does not still resolve all possible use cases (if you want to report from Wednesday of week 1 to Tuesday of week 2, you still won't have the correct data)
Here is an explaination AND a potential solution
The solution outlined makes everything a little more complicated (you'll have to create a DAILY fact, a WEEKLY fact, a MONTHLY fact etc.) *and* does not still resolve all possible use cases (if you want to report from Wednesday of week 1 to Tuesday of week 2, you still won't have the correct data)
or you can spend 499/599$ /year
https://www.cdata.com/drivers/ganalytics/powerbi/
(note: cdata is quite well known, but i NEVER used this connector)
cdata doesnt help unfortunately... it still doenst show the correct total users or sessions i na given time period. its the same as native connector which shows correct data by day but when ou want to see the overall users, its wrong
