Forum Discussion
Connecting to multiple tenants/directories
I want to create a PowerBI dashboard that contains data from multiple tenants that we have. I am a guest user in them with the Global Admin role available. I understand that I need to create an app in each tenant but I can't figure out how I'm supposed to actually make the connection to each tenant. When I log in I'm doing this to the primary tenants, when I'm in the browser, i can switch directories to get to each Identity Secure score, how can I do something similar in PowerBI?
Hi Dean_Gross,
You can try signing in to the Graph Security API Connector with the accounts for each tenant.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-graph-security
To switch tenants from Power BI:
File > Options and settings > Data source settings
Select Microsoft Graph Security Connector, click Edit Permissions, then Edit under Credentials. You can then sign in with the appropriate account for the tenant.
- After I create the app in each tenant, how do i use the app id in my query ?
- Thanks, but it’s the same account in each tenant. It’s a guest account in multiple tenants so I don’t understand how those instructions will help
