Problem with sessions for hour of Google Analytics API

[jduran]

Hello everyone.

 I am consulting with Power BI Desktop the sessions for hour of Google Analytics API. My problem is that when adding the information of the sessions, to get the total of sessions of a month, I get three times more sessions than if I access the information of the sessions segmented only for months.

 Someone has encountered the same problem and knows how to fix it.

Any help actually appreciated

Thank you

[jduran · Accepted solution]

Thank you very much.

I think the problem was in the interpretation of the data, since there may be sessions that belong to several hours and adding the sessions of all hours is doubled information.

[v-yuezhe-msft]

Hi @jduran,

Could you please elaborate your scenario with screenshots? Do you get the above issue when connecting to Google Analytics data in Power BI Desktop?

Thanks,
Lydia Zhang