AD connector Fails to save modifications to the server?

[ovonel]

I am consuming from Active Directory connector; and, I start to get the data, but at around the row 20,000 I get this error:

I am pretty much following this guide: https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/

PowerQuery:

I remove Nulls before consuming too:

Consuming only 2 columns:

Any idea how can I prevent it from failing?

[collinq]

Hi @ovonel ,

I am not aware of a limitation on the number of rows or why it would fail at a row count.  I am wondering if it is timing out?  I would be interested if you would try this article's method as well and see if you get a different result?

Power BI and Active Directory for System Administrators (biinsight.com)