After creating the sub-organization and adding Users with permissions to it, a user with the System Administrator role must switch from the parent organization to the newly created one from the Organization drop-down snippet:
Afterward, the reporting setup and tenant connection should work as expected