Create subscriptions for dynamic number of pages

[skrishnamurthy]

How to create subscriptions for reports sent out automatically that has pages growing dynamically at the end of each month.

For example a rolling fin year report showing product list details for each month will grow in pages as the number of products keeps increasing. Ex: Jul 2019, 10 different products sold with their details occupying 1 page. In Aug 2019 , 3 new products from the same supplier was sold which flows through to a new page. This report is sent out to a external email address from Power BI Premium account.