Initial refresh to get past

Morning, never experienced this but I think the following might work. Are you starting off life in PBI Desktop? If so configure the IR with a very narrow range that will only load a small amount of data and publish it to the service.

It should hoepfully publish. At that point you need to force a refresh in the service so that it setups an initial policy and partitions:

Then you need to connect to the XLMA end point with tabular editor and "modify". I've tried with TE 2 so that it's "free":

1) CLick IR table and in property pain you should see:

2) Change the RollingWindowPeriods to what you need:

3) Click save changes to connected database.

4) Right click the table and click "Apply Refresh Policy" which should generate partitions

5) You can then refresh each parition in turn either from TE or SSMS.

Hoping that works!