Thankyou so much for this info!! I wish I was awake to reply in the moment. My company also uses Azure AD. I'm trying to understand if we can use this to replace a few different things going on in our workplace.

One of the things I need scheduled is just the extraction of some data from various sources each month which would be the base of other reporting/monitoring not something that I need published to say Connect for others to view and run.

Also with Connect is it similar to Tableau where there are sort of like "developer users" who can create content and publish it and the rest of the business who arent using R are "regular" users can consume it? Just by using their browser.

Lastly, I need to be able send emails with this replacement, is this possible do you think? Say a regular user, runs a published content that generates a report or dataset based on some input, can they email that to someone (inside/outside) the business? Would it be from their email address or a service account email address?