Google Analytics Not Pulling Certain Dates

[Jaikrit94]

Hello,

I am working on a dashboard that hasn't been updated since June 2016. The data sources for the dashboard are the Google Analytics API and a simple excel spreadsheet. 

As you can see from the above screenshots, for some reason, the months of July 2016 and August 2016 are not reflecting any data. I looked at this exact timeframe in Google Analytics in the Channels tab and there is data there. Any idea what might be causing this issue?

Thanks!

[mdannemiller]

Do you have any filtering on the data at the query level?  Otherwise I'd see if you can get an excel or csv export of the data and see if there is some issue with the data coming out of GA.

[Jaikrit94]

There was filtering on the query level (in the advanced editor) which I have addressed. Thanks for your input!

[v-yuezhe-msft]

@Jaikrit94,

How about removing legend from your visual? Would you mind sharing me the PBIX file?

Regards,
Lydia Zhang

[Jaikrit94 · Accepted solution]

I have actually managed to resolve the issue by looking at the queries in the advanced editor. Thank you for your assistance!

[v-yuezhe-msft]

@Jaikrit94,

Glad to hear the issue is solved.  You can accept appropriate replies as solutions to close this thread.

Regards,
Lydia