loop connection for multiple exchange online account

[Anonymous]

Hello everyone,

I'm facing a problem, i need to extract multiple calendar information to perform cost analytical. I use exchange online connector.

for just few account it's not a problem to connect manualy, but for hundred account it is.

Do you know if there is a way, maybe lwith loop,  to connect those accounts from a list ?

i use administrative account with full access right and connexion with microsoft account to connect each user's account.

I hope there is a way to do that to save much time.

Bye !

[Dreyzzyn]

Any knowledge on if we can automate the exchange online sign-in? I have to iterate through several hundred mailboxes, and it prompts for credentials (Microsoft SSO) for each one.

[JohnsonMatangi]

hi,

using above facing issue related to scheduled refresh in power bi not shown can any one help me with this.

[Anonymous · Accepted solution]

@Anonymous,

Assume that you are connecting to the calendar table. Firstly, add a new blank query in Power BI Desktop, then paste the following code into Advanced Editor of the blank query.

(Account as text) as table=>

let
    Source = Exchange.Contents(""&Account&""),
    Calendar1 = Source{[Name="Calendar"]}[Data]
in
    Calendar1

Secondly, create a table containing all the exhange account you need to loop.


Thirdly, in the table, invoke the function created in step 1, then expand the calendar column.


There is a similar video for your reference.
https://www.youtube.com/watch?v=6PZSZ53iSos

Regards,
Lydia

[JohnsonMatangi]

hi,

using above query sucessfully connected to mutliple accounts but , schedule refresh option is not shown in power bi service , could any one please help me with this .

[Anonymous]

Just perfect, thank you so much !

maybe a last thing do you know when exchange online connector will be able to auto-refresh data in powerBI service ?