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.
I am trying to pull a report from Smartsheet onto Power BI that has 20,000+ rows and 34 columns.
If I lower the amount of rows I am pulling into Power BI, the data refresh works without any problems. I've also tried isolating the issue to see if it was a particular row causing a problem. The error message I receive only shows up if there are over 10,000 rows.
The error message I see is "OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get the contents from https://api.smartsheet.com/2.0/reports/6244860874254212?pageSize=500&page=23' (429):Too Many Requests."
Now one interesting thing that changes is the page that error happens on (sometimes its page=23, sometimes its page=15).
I am using the most recent update of Power BI.
I have tried reconnecting my Smartsheet account on the data settings page. I've also tried redirecting the data to the correct report on Smartsheet.
Nothing has seemed to work besides lowering hte number of rows that I process.
Is there a solution that doesn't require me pulling from multiple reports on Smartsheet and appending them together?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.