Forum Discussion
Data is cut off at 100 rows
It appears there is a major bug in Power BI: data is cut off at 100 rows. 101st row, in our case, shows this error: DataFormat.Error: OData The format 'application/atom+xml;charset=utf-8' is not sup...
100RowsLimit - I would recommend turning on Tracing, File | Options & Settings | Options | Diagnostics | Enable Tracing and then run a refresh. Go to support.powerbi.com, use the Contact Us link on the right (scroll down) and send them all of the information, including your trace file. This is the official manner in which to submit bugs to support to make sure that they are tracked and resolved.