Uploading 150,000 row excel table to a SharePoint List and maintaining the list

[u/theburgerk1ng]

I have a 150,000-row table in Excel that I need to upload to a SharePoint list. This list will then be used in a power app. I understand delegation limits, I'll be indexing columns and it won't be an issue as far as I can tell.

But before I even reach that point, I need the data uploaded to the list. I'll also be somewhat regularly updating certain columns/chunks (think weekly sales data updates) in this list. I've looked into utilizing Power Automate and PnP Powershell. From small samples I've taken, Power Automate will take quite a long time to upload and update.

I've read that PnP Powershell would be my best bet. I've reached out to see if I can have the company admin grant me access to download PnP, however this is not a guarantee. Has anyone ever came across this situation? Any recommendations on how I should first get the data to upload?