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)
(you can see this behaviour if you choose just one day in PowerBI, data will match GA)
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
