Google Analytics report refresh error in Power BI

Power BI
1

Hi All,

I am using Power BI to develop a google analytics dashboard using the default(3rd party) ‘Google analytics connector’ available on the Power BI desktop.
I encountered errors and runouts whenever I refresh power query steps in both the Power BI 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
  1. 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.

Is this related to the google analytics connector? is the issue on the google analytics API side or on the Power BI side?

Thanks,

2

Hi @jojo,

With just reading the issue it’s hard to tell weather it is API or not. It might depend on the amount of data you are requesting within given time frame, if you send too many request then there are chances that you will get errors. If you share the sample pbix file then would be easy to see what’s going on.

Thanks
Mukesh

3

Hi @jojo , we’ve noticed that no response has been received from you since the 29th of January. We are waiting for the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

This will help other users and experts to answer your inquiry better. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.