Google Analytics in Power BI refresh issues

Power Query
1

Hi All,

I am developing a web analytics dashboard in Power BI using the default ‘Google analytics connector’ available in Power BI.
I am having a painful fail whenever I refresh power query steps in both desktop and service.
I cannot figure out what exactly is happening because every time the error messages are different, and sometimes a couple of queries load and others don’t, on other times the opposite. here are the errors I often get:

  1. Waiting for www.googleapis.com — the refresh run out and fails
  2. OLE DB or ODBC error : Exception from HRESULT:0x80040E4E
    3)OLE DB OR ODBC Error:[DTSource.Error] There was an internal error
    I do not apply any heavy power query steps except the default steps and filter the date parameter.

What should I do? any workaround? is the issue on the google analytics API side or Power BI side?

2

Hello @jojo

Haven’t used Google Analytics. However a quick search has got below Microsoft link that provide some information on Connector and limitations. Please check if this is helpful.

I will suggest also to try raising issues at Microsoft Developer forum.

Thanks
Ankit J

3

Hi @jojo, did the response provided by @Ankit help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

4

Hi @jojo, we’ve noticed that no response has been received from you since the 28th of January. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

5

Hi @jojo, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!