Intent is to retrieve all or a subset of emails from all users within the organization into Power BI. So far, I've explored two methods, both functional but not without their drawbacks.
First, I attempted the Graph API. I made two calls: the first to retrieve all userPrincipalNames (i.e. email addresses), and the second to pull emails for each email address. Limiting my pull to 10 emails per address came back reasonably quickly, but retrieving 100 took considerably longer. Retrieving 1000 never completed, indicating inefficiency unless I'm overlooking something.
Second, I explored the Exchange Online connector. This approach is significantly faster. I don't even need to cap the number of emails. Retrieving 6000 emails for a single email address took only seconds. However, the issue arises when Power BI requests credentials for every email address. As an organization admin, I can use my master password, but this is not scalable. What if there are 10K users? Even if I address this, what happens when a new user is added? I would need to come back and provide credentials for the new user.
There must be a solution to this, and I'm inclined towards the second approach.
I'm more familiar with Power BI than Microsoft 365, so I suspect there's a method in the Azure admin portal for delegating access to the organization admin account.
