PowerBI reports not returning any export data

If you see issue similar to https://soteria365.freshservice.com/a/tickets/5352?current_tab=details

Please check if the report data export setting has changed on the file format export - It has always been defaulted to 150,000 max rows but it has now defaulted to 500,000 row and that will not extract the data and pulls it through in a different format. We need to change this setting before running the report export.

DevOps user story will be raised to retain the setting of 150k max rows as a default.