SharePoint Folder Data Flow Unable to Access More Than 100 Records

I am trying to create a dataflow off a SharePoint folder. For some reason I can only access the first 100 files that appear in this folder, even though there are many more that exist in the folder.

There is no problem with performing the same logic in Power BI Desktop, but for some reason I can’t access any files except the first 100 in the data flow.

Could you please investigate this issue ASAP and let me know what is going on?

Thanks

Eric

Data Modeling

3 Comments

jonathankapoor
Frequent Visitor
6 years ago
I am also having this issue. All my dataflows have stopped working that use Sharepoint Online Folder connector. This is very urgent.
v-yuta-msft
Community Support
6 years ago
emarshall ,

Have you configured the "Keep top rows" in query editor?

Regards,

Jimmy Tao
leed
Advocate II
6 years ago
Hi,

Same issue since last week:
https://community.powerbi.com/t5/Issues/Power-BI-dataflow-connect-to-sharepoint-folder/idi-p/924504

Please check,

SharePoint Folder Data Flow Unable to Access More Than 100 Records

3 Comments

Completed Ideas

Set as landing page feature missing in Apr 2026 update (Build 2.153.1206.0) both in Desktop and Serv

Input Slicer Bug: Cursor jumps to position 0 and values cannot be cleared in Service

Input Slicer Causing Browser Tab Freeze in Public Links (Started April 24, 2026)

Small multiples not fitting to scale

Previously working Mac calender visual now gives me a error every time I touch it!

Text Slicer does not reset via Bookmarks or Clear All in Power BI Service (Service-only behavior)

Text Input Slicer is not reset by bookmarks in Power BI Service while working correctly in Power BI

Azure maps not displaying mapped data points in publish to web when location used

Azure Maps reference layer transparency behaves differently after publishing to Power BI Service

Desktop Application Bug?? - PBI desktop application left navigation icons always solid black