Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
JohnsonMatangi
Regular Visitor
3 years ago

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 .