Sharepoint throttling - Dataverse as an alternative?

[Zerotto]

Hi there, 

I'm running into a throttling problem when trying to 'List rows present in a table' and the excel file is stored on SharePoint. The excel file has 80000+ rows that I need to filter and then extract data to then Add new rows to Dataverse tables. 

If I run the flow with concurrency on the Apply to each action, it fails and I get a 429 error, which indicates I'm hitting the request limit. The flow works when I turn all concurrency off however, it take too long. I need to be able to use concurrency to some degree.

I was thinking I could have the Excel file saved in a Dataverse row using the File type column. 

I have 3 questions - 

1. Will I run into similar throttling problems with Dataverse? 

2. If Dataverse is suitable, how do I use that as a location when setting up the List rows present in a table action? (i can't seem to figure that out)

3. Are there alternative ways to get around throttling when using Excel files? Would OneDrive also have the same issue?

Many thanks, 

[ScottShearer]

@Zerotto 

Before going further, have you tried using OData filter queries with your list rows in a table action?  If not, this might be your answer.  You can filter the rows returned so that only the rows that you need are returned, not 80000+.

[Zerotto]

Thanks for your reply. Yes I have used a filter query to only return the rows I'm interested in.

I have an 'Apply to each' that to loop through 100 records, each loop needs to List rows with a certain value, that I'm filtering for.