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 c...
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
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.