SharePoint Folder Data Flow Unable to Access More Than 100 Records

[emarshall]

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   

[jonathankapoor]

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]

@emarshall ,

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

 

Regards,

Jimmy Tao

[leed]

Hi,

Same issue since last week:

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

Please check,