Forum Discussion
Data refresh issue with google analytics source
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.
2 Replies
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.
To have a further diagnostic, Could you follow below steps?
- Enable the "File"->"Options"->"Diagnostics"->"Enable tracing".
- Capture network traffic by fiddler when refreshing in Power BI desktop.
- 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.
Eric_Zhang : I will try this. Thanks
