Cannot import large sharepoint online library from PowerBI RRS feed

  • Question

  • Hi,

    I'm trying to import a 5,300 rows SharePoint Online library with 60 columns.  Process starts but then stops with error IndexOutOfRangeException. Is there a way to get around this?

    I'm able to import 1,000 rows, but not more.  Even if I try to import rows 990 to 1,001 it fails.  I tried from Exel, same issue.

    I'm able to import a different  25,000 rows library but with 10 columns.

    So I guess is a combination of number of rows plus columns.

    Is there another way to import this data to another repository (SQL server, or other) and then query from PowerBI?


    Saturday, January 4, 2020 12:05 AM