Dataset Refresh Issue

hchava1104 — Wed, 20 Sep 2023 13:55:40 GMT

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

Re: Dataset Refresh Issue

BIDanny — Thu, 21 Sep 2023 15:31:40 GMT

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

topic Re: Dataset Refresh Issue in Developer

Dataset Refresh Issue

Re: Dataset Refresh Issue