Scheduled Refresh Failing on Exchange Data due to Cyclical Reference

[Anonymous]

trying to gather data directly from Exchange online to query multiple group mailboxes. 
I've done this previously with one inbox and it has been refreshing properly for months uninterrupted. 

Currently there are 10 inboxes being appended into a single table which is causing issues with the below error

I've tried a couple different things but seem to be hitting a wall. 

[v-deddai1-msft]

Hi @Anonymous ,

This seems to be a problem of circular dependency. If you are working with two tables and the second table is dependent on the first table, then you join with Master PDB TEMP. What you can do is create a reference to MASTER PDB TEMP and editing Table 2 to the new referenced query. A new query should help you resolve the error.

Please refer to the similar thread: https://community.powerbi.com/t5/Desktop/Append-2-tables-expression-error-a-cyclic-reference-was/td-p/521014

Best Regards,

Dedmon Dai

[GilbertQ]

Hi there

I am assuming that this works fine in Power BI Desktop?

If so do you have the latest version of the Gateway installed?

Also what if you use a function to call the mailboxes?