Forum Discussion
loop connection for multiple exchange online account
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 !
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
5 Replies
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,
Lydiahi,
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 .
hi,
using above facing issue related to scheduled refresh in power bi not shown can any one help me with this.
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.
