Forum Discussion
Power BI gateway doubt
Yes you need to add them here so they map their semantic models to this data source when they publish and yes, using security group is a valid option to lower manual effort in the fabric tenant. We use that approach for our customers.
I'm not sure I got you 100%, I don't know what you mean with "Power BI server":
- Power BI Report Server is a SQL Server component to run paginated and dynamic report on-prem
- On-prem data gateway is the service to make Power BI Service communicating with on-prem
anyway, if you migrate across tenants (i.e. moving power bi from @contoso.com to @wwi.com) you don't migrate the gateway you'll have to create a new one since the tenant is different, therefore you should reacreate everything on the new tenant (datasources included and users assignement included).
on the other side, if you stay in the same tenant and you only change machine you can migrate the gateway with the migration process (you need the recovery key which you used during the first installation).
There are probably different nuances if the tenants are federated. Are they federated?
If I didn't get your case, please explain it better.
thank you for the reply.
To clarify – when I mentioned “Power BI server,” I was referring to the On-premises Data Gateway, not Power BI Report Server.
For our tenant migration to Tenant B, we have:
a. Created a new dedicated VM
b. Installed a new On-premises Data Gateway on that VM
c. Configured the required Oracle and SQL Server data sources
d. This gateway is registered under the new tenant (Tenant B)
Since gateways cannot be migrated across tenants, we rebuilt everything from scratch on the new VM, including data sources and user access.
Please let me know if this clarifies the setup.My question was:
If we have 5 users who publish/use reports with the Oracle data source through this gateway, do all 5 users need to be added under the Gateway → “Manage Users” section?
Should we add them here i.,e by
Adding them individually under “Manage Users”, or
Adding a security group that contains these users.
Please confirm if this is correct for our setup.Yes you need to add them here so they map their semantic models to this data source when they publish and yes, using security group is a valid option to lower manual effort in the fabric tenant. We use that approach for our customers.
