Paginated report dynamic schedule

Question

I am building a paginated report in powerbi but stuck in schedule part. The report should be sent the 1st day of each month with last month data ex: 01/09 a report should be sent with data of 01/08 to 31/08

i have a analyst service as source and create a table which take all the date of the past month but unfortunately cannot able to make a relationship