Why do I get a 404 error using Pagination in Dynamic Posts with Query Type - Dynamic Current Query?

On Dynamic Posts, if you are using the pagination in the Query Type "Dynamic - Current Query", the number of results per page should match the value you set in WordPress "Settings > Reading > Blog pages show at most".

Note: In the case of WooCommerce Products, you can just go to Customizer > WooCommerce > Product Catalog, and make sure the number of rows per page and products per row equals the products you want to show per page.
​

If the values are mismatched, you can encounter a 404 error.
​