Dataset Refresh Issue

[hchava1104]

Hi All,

My use case is to connect google sheets with power bi desktop and develop the dashboard. My part is done i have developed the dashboard and published it to service. I have scheduled the refresh in power bi service. I have installed personal gateway for the same. For few days it worked well but now refresh got failed from past 3 days. I am not sure why this is happening and my gateway status is also online.

Below is the mentioned error:

Can someone please help me here

[BIDanny]

Looks like you've hit a per-user limit on requests to that doc via their API.  In the error message, you can see the HTTP Response Code (429), I've provided a link below to their developer documentation for your reference about this error.

Resolve errors  |  Gmail  |  Google for Developers

Maybe try hosting that data source in Sharepoint or Onedrive to avoid that, if possible.

Typically when I see these strange data source issues, I just throw the error message into Bing/Google and peruse the results.  Sometimes it's helpful, sometimes its not 🙂

Dan Rolfe

Dobler Data Solutions