Forum Discussion
Sharepoint Data Connection ("Operation Timed Out Error")
Hello Everyone,
I've connected my data from a SharePoint Folder into Power BI Desktop.
In the SharePoint folder, I store monthly Excel files, which are then combined in Power Query.
Recently, when I added the latest file, I encountered an error:
"Operation Timeout Error"
After investigating, I found that the new file had more than 5000 rows. When I reduced it to 5000 rows or less, everything worked fine. However, increasing the row count again caused the timeout error to return.
This made me wonder:
Is there a row limit when using the SharePoint folder connector in Power BI?
Or is there a performance limitation causing this timeout for large files?
I’d appreciate any insights or best practices for handling larger Excel files in SharePoint with Power BI.
Thanks in advance!
lbendlin d_gosbell rohit1991 SolomonovAnton uzuntasgokberk Greg_Deckler
Hi Rudresh8690,
Since the issue still persists despite the troubleshooting steps, I recommend raising a support ticket so that one of the engineers can investigate it further and provide a solution to the issue you are facing.
You can raise a support ticket using the link below:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
9 Replies
Rudresh8690 It is likely due to performance limitations with large files in SharePoint. Power BI struggles with sharepointconnector
Please Check this thread for detailed information which explains the situtaion
https://www.reddit.com/r/PowerBI/comments/1fnxcsl/sharepoint_connector_limitations/Hello Akash,
I am using the SharePoint Folder Connection, so does Power BI treat Excel Files as Lists?
As much as I have researched, there is a limit of 5k rows in lists, even that's not properly mentioned everywhere so I have doubt in that.Hi Rudresh8690,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Thank you Akash_Varuna, for your insights.
Power BI does not treat Excel files from a SharePoint Folder as SharePoint Lists, so the well-known 5000-item threshold from SharePoint Lists does not apply in this case. The timeout error you’re encountering is more likely related to performance limitations rather than a strict row limit. When Power BI connects to a SharePoint Folder, it relies on SharePoint’s REST APIs to retrieve and combine files, and this process can become sluggish especially with larger files or when multiple transformations are applied in Power Query.
Try optimizing your Excel files by removing unnecessary formatting, formulas, or columns, which can significantly reduce load time. If you're using the default Combine Files function in Power Query, consider applying row or column filters as early as possible in the query steps to minimize the volume of data being processed.
If you're working with just a few large files, another effective approach is to use the Excel Web connector by pasting the direct file URL from SharePoint. This bypasses the SharePoint Folder API overhead and is often faster. If your data volume continues to grow, you might want to explore using Power BI Dataflows, which run in the cloud and can handle larger datasets more efficiently than Power BI Desktop.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
