Google Analytics Data Does not match up with Power BI - Except Daily Users

[wferrell]

Hello,

As a new PBI user i am not sure where the issue from GA is coming from.   Is this sampling?  or soemthing else?  pleasee see screen shots below - i am looking at July 31st as a test date.  Any help on this is greatly appreciated!!

Thanks,

WIL

[v-qiuyu-msft]

Hi @wferrell,

In Power BI, the Google Analytics connector in Power BI Desktop rely on the Google Analytics Core Reporting API. Although we attempt to release updates in accordance with any changes, the API may change in a way that affects the results of the queries we generate. In some cases, certain queries may no longer be supported. Due to this dependency we cannot guarantee the results of your queries when using this connector.

In your scenario, please try to run the Power BI desktop latest version, currently is version 2.48.4792.721 64-bit (July 2017). Make sure the data retrieved based on the same date range. Please don't use table visual to display data then compares with Google Analytics data, as there might have aggregation function applied for the column in table visual. Please go to Query Editor, filter out the data for July 31.

If the data display in the Query Editor is different from the Google Analytics exactly, the issue may be related to Google Analytics reporting API, please post a thread here based on this article.

Best Regards,
Qiuyun Yu