Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning guys,
I'm trying to refresh a dataflow that will have all the necessary data for DI&A teamDashboards, This dataflows is loading about 50 different entities and the biggest has 2.5 Million rows.
In this case I'm only loading one year of history and the incremental refresh will only load the last 3 days. However I'm not succeeding with this refresh
Ex:
This is the returned Error Message:
Error: Data Source Error : DataSource.Error: ERROR [HY000] [Microsoft][BigQuery] (31780) Not found. Exceeded rate limits: too many api requests per user per method for this user_method. For more information see https://cloud.google.com/bigquery/troubleshooting-errors .. RootActivityId = 59651e37-4ca3-4347-b904-8343a5b546e8.Param1 = DataSource.Error: ERROR [HY000] [Microsoft][BigQuery] (31780) Not found. Exceeded rate limits: too many api requests per user per method for this user_method. For more information see https://cloud.google.com/bigquery/troubleshooting-errors Request ID: 8864254e-a992-4c7c-bfb0-0bcc58ea7f5b.
I'm testing it on a Worsksapace PPE License, and I have exactly the same dataflow on a Workspace Pro License without incremental refresh and it works perfectly (despite the exaggerated refresh time).
Has anyone experienced something similar? Any suggestion?
Thanks a lot!
Copy the query to Power BI desktop and run Power Query diagnosis on your query - it will show you the full request traffic.
As you can see from the error message the incremental refresh process is too chatty for the Big Query server's taste. Can you increase your API call rate limits?
hi @lbendlin, i already checked my quotas and in terms of requests I dont' have any limitation:
What i saw is that with whis kind of Limit Quotas i shouldn't have any contstarins or issues.
Could it be any issue with the Power BI default connector?
I'm runnig out without ideas to solve this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.