During a Power BI migration using Quest On Demand Migration (ODM), the following error may occur:
“Gateway Datasource has not been migrated yet”
or
“Failed to add user to the gateway connection”
This error typically appears when attempting to migrate Power BI workspaces or assign user permissions before the required underlying gateway datasource (connection) has been successfully created in the target tenant.
Power BI migrations require a strict dependency order. Workspaces, reports, and permissions depend on existing Connections (Datasources), which themselves may depend on Gateways.
If a connection (datasource) referenced by a workspace or report does not exist in the target tenant, Power BI cannot bind reports or assign user access. As a result, the migration fails with a "BadRequest" or "Failed to add user error".
In most cases, this issue occurs because the Migrate Connections step was skipped or not completed successfully.
To resolve the issue, ensure that all prerequisite objects are migrated in the correct sequence.
Required migration order:
Quest ODM does not migrate On-Premises Data Gateways automatically.
Gateways must be manually created and configured in the target Power BI tenant before proceeding.
After the target gateway is created, run the Match Gateways task in ODM to associate the source gateway with the corresponding target gateway.
Each discovered connection must be assigned a Connection Profile (credentials).
Without this, ODM cannot recreate the connection in the target tenant.
Run the Migrate Connections task for the affected connection (for example: xxx-xxxx-xxx-xxxxx).
This step creates the actual Gateway Datasource in the target tenant.
If this step is skipped or fails, subsequent workspace and permission migrations will fail.
Once the connection status shows Migrated, you can safely run the Migrate Workspaces task.
Reports and associated user permissions will then be applied successfully.
NOTE: Before re-running the workspace migration, verify the followings:
Target gateway exists, is online, and correctly matched.
A Connection Profile is assigned to the source connection.
The Migrate Connections task completed successfully for the required datasource.
