sysauto_report export issue

[Reddymahesh]

We have scheduled auto report set and type is set to excel and when report is generated to email we are getting its an PDF. Any suggestions on how to fix this issue

[Its_Azar]

Hi there @Reddymahesh 

This could happen if the run as user does not have sufficient privileges to export the scheduled report as xlsx. 

1. Change the run as user in the scheduled report to a higher privileged user (or an admin user) and check if the report exports correctly as Excel. 

2. Verify the report template and scheduled report configuration on the production instance to ensure the format is set to Excel.

3. Check the emails sent from the scheduled report to confirm the attachment format matches the configured format.

[Reddymahesh]

@Its_Azar  I have previoulsy checked this SNOW KB. We can't have run as user with admin role assigned. Any other roles we need to cross check or provide

[Its_Azar]

Hi @Reddymahesh ,

There would any some other privileges roles other than admin depending on your setup

, can you try with those?

[Its_Azar]

Hi there @Reddymahesh 

Try these

report_user 

report_admin 

export_user