When getting tables from an Excel file that resides in SharePoint, there is a limit of 256 rows that can be fetched. This limits the usability of this function. The corresponding function for use with an OneDrive for Business-hosted file has a limit of 2,048, which is still fairly low (we have many folks with spreadsheets of 8-10,000 rows or more). I'm still not sure I understand why separate sets of actions are available based on where the file is stored.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.