loop connection for multiple exchange online account

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