You can’t email a report to a group that doesn’t have access to the report. So having two reports means exposing the group(s) to two reports. And maintaining two reports. And it’s more than I want to (or should have to IMO) do.
The promise of the automation was emailing a Data Explorer query, so that’s what I expected to happen
ETA: I’m currently scheduling a third (different) report. We have too many reports that I want to send out to maintain duplicates