100 Row Limit

[jmfillman]

I have a DataFlow that connects to a SharePoint list, with about 415 records, at current. The BI PowerQuery show a stat of 99+ rows, but only shows 100 rows. I cannot find a hard limit set anywhere that restricts the returned rows to 100.

This appears to be a hard limit somewhere, but web searching and searching here doesn't meantion anything like an account type limitation that is 100 rows. A report against the data is also only using the same 100 rows, whether in Power BI Desktop or when viewed online, added into PowerPoint, etc.

I'm stumped with this and need some help.

[ppm1]

Were you looking only at the preview window (which may be limited to 100 rows)? Or did you load the data and still only see 100?

Pat

[jmfillman]

I actually found this when the counts on a pie chart were wrong and tacked it back to the DataFlow limit

[Anonymous]

Hi @jmfillman ,

You could try to disable the following option to see all data. 

Disable Power Query background refresh - Power BI | Microsoft Learn

Power Query, Power BI And The “Allow Data Preview To Download In The Background” Option

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[jmfillman]

Hi Stephen, 

My admin group pushed me towards DataSets after they couldn't find a reason for the load limit either. I went back and tried your suggestion and still having the row limitation, but moving forward with DataSets instead.