Data refresh issue with google analytics source

[Sunkari]

Hi Team,

I have created a PBIX file which is pulling data from Google analytics source. PBIX has more than 40 power queries. I am facing the following issue while refreshing the PBIX in Power BI Desktop.

Sometimes queries are running faster and executing without any issues but some cases they are blocked and not at all executing queries.

It seems like some blocking is happening while running more quires against google analytics. 

Anyone faced this kind of issues. Please provide your inputs.

[Eric_Zhang]

---

@Sunkari wrote:

Hi Team,

I have created a PBIX file which is pulling data from Google analytics source. PBIX has more than 40 power queries. I am facing the following issue while refreshing the PBIX in Power BI Desktop.

Sometimes queries are running faster and executing without any issues but some cases they are blocked and not at all executing queries.

It seems like some blocking is happening while running more quires against google analytics. 

Anyone faced this kind of issues. Please provide your inputs.

---

@Sunkari

To have a further diagnostic, Could you follow below steps?

1. Enable the "File"->"Options"->"Diagnostics"->"Enable tracing".
2. Capture network traffic by fiddler when refreshing in Power BI desktop.
3. Zip the trace folder(C:\Users\username\AppData\Local\Microsoft\Power BI Desktop\Traces) and fiddler log and upload to a network drive and share the link

By the way, please follow  the same steps for your another thread Publish to service issue with Google analytics as well. 

[Sunkari]

@Eric_Zhang : I will try this. Thanks