The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I am decently new to Power BI and analytics in general, so I apologize if there is an easy solution to this. I am running a report that connects to five different Google Analytics views for the five websites of my organizaiton. I have successfully loaded them into Power Query, but when I hit "Close and Apply" I get this error message.
"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: GoogleAnalytics: Request failed (403): Quota Error: Number of recent failed reporting API requests is too high, please implement exponential back off. See developer documentation for details at https://goo.gl/NIdnFC. ".
I have no idea how to solve this. I have tried searching community posts and Google but nothing comes up besides another Community post from 2017 that did not come to a resolution. Any suggestions on how to resolve this or where to implement "exponential backoff" would be great. Thanks.
Without much detail, looks like you are having issues getting your data due to errors. GA tells you that you're retrying too frequently. Exponential backoff means that you should make longer wait after each error.
That is what I logically thought as well. I left work on Thursday and did not try again until this morning (Monday) and got the same error right away. Why would my data load correctly in Power Query but not in Power BI Desktop? Each of them individually loads fine, but when I append them together and try to load all five, I get this error.
I am pulling in these fields for each of the five websites and then appending them together to get one big table:
Sessions
Pageviews
Bounce Rate
Default Channel Grouping
Date
User | Count |
---|---|
86 | |
83 | |
34 | |
34 | |
32 |
User | Count |
---|---|
94 | |
79 | |
62 | |
54 | |
51 |