Chat now with support
Chat with Support

On Demand Migration Current - User Guide

About On Demand Migration Working with On Demand Migration Account Migration Mailbox Migration OneDrive Migration Microsoft Teams Migration Microsoft 365 Groups Migration SharePoint Migration Public Folders Migration Power BI Migration Troubleshooting Finalizing the Migration Appendix A: Using PowerShell Appendix B: How Queuing Works

Power BI Migration Workspace

NOTE: The Power BI migration workspace is a On Demand Migration project workspace, and should not be confused with Power BI Workspaces that are objects of the Power BI asset type.

In this topic:

Dashboard

The dashboard in the Power BI migration workspace presents a summary of the Power BI migration activities and links to important actions. The components of the dashboard are as described below:

Notification panel - presents relevant information and shortcuts to migration activities. Appears when a notification is available.

Dashboard menu - contains the following links to common activities in the migration process.

  • Connect to Power BI - starts the New Test Power BI Connection Task wizard that verifies the security requirements to connect to the Power BI application in the source and target tenants. See Connecting to Power BI for more information.
  • Configure Project - lets you specify a default administrator for Power BI object migrated to the target tenant. To configure the project follow the steps described below:
    1. Click Configure Project. The Edit Project page opens
    2. In the Default Target Admin User field, enter the user principal name (UPN) of the target tenant administrator.
  • Discover All Contents - Starts the New Discover All Contents Task wizard to discover all Workspaces, Gateways and Connections in the source tenant. For more information see Discovering Content.
  • Collect Statistics - Starts the New Collect Statistics Task wizard to collect information needed for detailed premigration report which includes Power BI Reports, Users and Object Roles in addition to Power BI content.

Dashboard Tiles

  • Getting Started - displays quick start links and instructions about various actions for preparing and migrating Power BI Connections and Workspaces.
  • Workspaces with Status - displays a summary of the Power BI Workspaces in various migration states. The title displays the total number of workspaces with status. Click Show All to open the Workspaces List view to inspect the Workspaces.
  • Gateways - displays a summary of the Power BI Gateways in various migration states. The title displays the total number of Gateways. Click Show All to open the Gateways List view to inspect the Gateways.
  • Connections - displays a summary of the Power BI Connections with pre-migration connection profiles: Assigned or Unassigned. A connection profile is a named set of credentials that is assigned to discovered Connections before they can be migrated. The title displays the total number of connections. Click Show All to open the Connections List view to inspect the Connections.
  • Connections with Status - displays a summary of the Power BI Connections in various migration states. The title displays the total number of connection. Click Show All to open the Connections List view to inspect the Connections.
  • Tasks - displays the five most recent tasks that were completed in the Power BI migration workspace. The title displays the total number of tasks. Click Show All to open the Tasks List view.
  • Events - Displays the five most recent events that were completed in the Power BI migration workspace. The title displays the total number of error events. Click Show All to open the Events List view.

Workspaces List View

The Workspaces List View is comprised of the following components:

Notification panel - presents relevant information and shortcuts to migration activities.

Filter panel - consists of predefined filters for the Workspaces List view. See Filtering for more information about working with filters. The predefined filters are:

  • Status - returns a list of Workspaces based on the selected status of the most recent task that was run for the Workspace. Valid values are New, Stopped, In Progress, Failed and Completed.
  • Workspace State - returns a list of Workspaces in the selected migration state. See the Migration State column description below for filter values.

List View Actions Menu - contains links to Workspace actions and the search box. Each action is explained in greater detail in subsequent topics. See Searching for more information about working with the search box.

  • Discover - starts the New Discover Workspaces Task wizard to discover Connections in the source tenant. See Discovering Workspaces for more information.
  • Migrate - starts the New Migrate Workspaces Task wizard. See Migrating Workspaces for more information.
  • Delete - deletes one or more selected Workspaces.
  • New Collection, Add to Collection, More > Import Collection - see Managing Power BI objects with Collections for more information.
  • More > Map from File - starts the New Mapping from File Task wizard to map specific Workspaces from the source to a Workspace that may or may not exist in the target tenant. See Mapping Workspaces for more information.

List View - displays information about Workspaces in the source tenant. Use Edit Columns to show or hide columns in the list. The columns are as described below:

  • Migration State - state of the task in the migration process. Values are as listed below:
    • Discovered - Workspace discovered in the source tenant.
    • Migrating - Workspace migration in progress.
    • Migrated - Workspace migrated successfully to the target tenant.
    • Migrated with issues - Workspace migration completed but there were issues during migration.
    • Migration failed - Workspace could not be migrated.
    • Stopped - Workspace migration has been halted.
  • Name - name of the Workspace in the source tenant.
  • Owner - the username of the owners of the source tenant workspace.
  • Target Workspace - displays the target workspace name when you map a source workspace to a target workspace with a different name.
  • Reports Count - number of reports in the source tenant Workspace.
  • Users Count - total number of users who have access to the source tenant Workspace.
  • Capacity - capacity level of the Power BI. valid values are Power BI Standard and Power BI Premium. Help you plan that the capacity in the target tenant.
  • Priority - indicates the precedence level of this object if it is included in a migration task where the priority is set in the Schedule step of the migration wizard. Values are: Highest, High, Medium, Low and Lowest. The default priority is Medium. If the system is busy, the objects are queued. When the system accepts new migration work, objects are taken from the queue based on the assigned priority and age in the queue.
  • Collections - indicates the most recent collection where the corresponding Workspace is added and the number of additional collections that also contain this object.
Workspace Details

When you select a Power BI Workspace from the List View, the Workspace Detail pane opens. The information in the pane is described below:

  • Description - name of the Workspace in the source tenant.
  • Events - count of the events that occurred during one or more tasks.
  • Tasks - list of tasks invoked for the selected Workspace .
  • Collections - list of collections that contain the selected Workspace.

Gateways List View

The Gateways List View is comprised of the following components:

Notification panel - presents relevant information and shortcuts to migration activities.

Filter panel - consists of predefined filters for the Gateways List view. See Filtering for more information about working with filters. The predefined filter is:

  • Matching - returns a list of Gateways in the selected matching state. Valid values are Matched and Unmatched.

List View Actions Menu - contains links to gateway actions and the search box. Each action is explained in greater detail in subsequent topics. See Searching for more information about working with the search box.

  • Discover - starts the New Discover Gateways Task wizard to discover Connections in the source tenant. See Discovering Gateways for more information.
  • Match - starts the New Match Gateways Task wizard. See Matching and Mapping Gateways for more information.
  • Export - exports one or more selected Gateways to a CSV file.
  • Delete - deletes one or more selected Workspaces.
  • New Collection, Add to Collection, More > Import Collection - see Managing Power BI objects with Collections for more information.

List View - displays information about Gateways in the source tenant. Use Edit Columns to show or hide columns in the list. The columns are as described below:

  • Name - name of the source tenant gateway.
  • Discovered On - date and time the source tenant gateway was discovered by a discovery task.
  • Target Gateway - name of the target tenant gateway.
  • Collections - indicates the most recent collection where the corresponding Gateway is added and the number of additional collections that also contain this object.
Gateway Details

When you select a Power BI Gateway from the List View, the Gateway Detail pane opens. The information in the pane is described below:

  • Description - name of the Gateway in the source tenant.
  • Events - count of the events that occurred during one or more tasks.
  • Tasks - list of tasks invoked for the selected Gateway.
  • Collections - list of collections that contain the selected Gateway.

Connections List View

The Connections List View is comprised of the following components:

Notification panel - presents relevant information and shortcuts to migration activities.

Filter panel - consists of predefined filters for the Connections List view. See Filtering for more information about working with filters. The predefined filters are:

  • Status - returns a list of Connections based on the selected status of the most recent task that was run for this account. Valid values are New, Stopped, In Progress, Failed and Completed.
  • Connection State - returns a list of Connections in the selected migration state. See the Connection State column description below for filter values.
  • Type - see the Type column description below for filter values.
  • Profile - returns a list of connection that either assigned or not assigned to a connection profile. Valid values are Assigned and Not Assigned.
  • Target Binding - valid values are Supported and Unsupported.

List View Actions Menu - contains links to Connection actions and the search box. Each action is explained in greater detail in subsequent topics. See Searching for more information about working with the search box.

  • Discover - starts the New Discover Connections Task wizard to discover Connections in the source tenant. See Discovering Connections for more information.
  • Assign Connection Profile - starts the Create New Connection Profile Task wizard to assign a Connection Profile to a discovered Connection before it can be migrated. See Creating and Assigning Connection Profiles for more information.
  • Migrate - starts the New Migrate Connections Task wizard. See Migrating Connections for more information.
  • Delete - deletes one or more selected connections.
  • New Collection, Add to Collection, More > Import Collection - see Managing Power BI objects with Collections for more information.

List View - displays information about Gateways in the source tenant. Use Edit Columns to show or hide columns in the list. The columns are as described below:

  • Name - name of the source tenant connections.
  • Connection State - state of the task in the migration process. Values are as listed below:
    • Discovered - Connections discovered in the source tenant.
    • Migrating - Connections migration in progress.
    • Migrated - Connections migrated successfully to the target tenant.
    • Migrated with issues - Connections migration completed but there were issues during migration.
    • Migration failed - Connections could not be migrated.
    • Stopped - Connections migration has been halted.
  • Type - the type of connection to a data repository. Valid values are File (any file that contains data like Microsoft Excel) and Sql (includes both Azure and on-premise SQL servers)
  • Users - displays all users who have owner right for the connection.
  • Discovered On - date and time the source tenant gateway was discovered by a discovery task.
  • Gateway Name - name of the gateway that is used by the connection.
  • Assigned Connection Profile - name of the Profile when it is assigned to the Connection.
  • Target Binding - Valid values are Supported and Unsupported.
  • Collections - indicates the most recent collection where the corresponding Connection is added and the number of additional collections that also contain this object.
Connection Details

When you select a Power BI Connection from the List View, the Connection Detail pane opens. The information in the pane is described below:

  • Description - name of the Connection in the source tenant.
  • Events - count of the events that occurred during one or more tasks.
  • Tasks - list of tasks invoked for the selected Connection.
  • Collections - list of collections that contain the selected Connection.

Connection Profiles List View

The Connection Profiles List View is comprised of the following components:

Notification panel - presents relevant information and shortcuts to migration activities.

List View Actions Menu - contains links to Connection Profile actions and the search box. Each action is explained in greater detail in subsequent topics. See Searching for more information about working with the search box.

  • Create - creates a new connection profile with user name, password and profile name for scenarios when you need to assign the same connection profile for multiple connections. Otherwise, use the Assign Connection Profile task from Connections tab to create and assign a connection profile to a specific connection.
  • Edit - updates the user name and password for an existing connection profile.
  • Delete - deletes one or more selected connection profiles.
  • New Collection, Add to Collection, More > Import Collection - see Managing Power BI objects with Collections for more information.

List View - displays information about Connection Profiles in the source tenant. Use Edit Columns to show or hide columns in the list. The columns are as described below:

  • Name - name of the connection profile.
  • Collections - indicates the most recent collection where the corresponding Connection Profile is added and the number of additional collections that also contain this object.
Connection Profile Details

When you select a Power BI Connection Profile from the List View, the Connection Profile Detail pane opens. The information in the pane is described below:

  • Description - name of the Connection Profile in the source tenant.
  • Events - count of the events that occurred during one or more tasks.
  • Tasks - list of tasks invoked for the selected Connection Profile.
  • Collections - list of collections that contain the selected Connection Profile.

Connecting to Power BI

The consents and permissions required to connect, access and migrate the Power BI application and data in the source and target tenants, requires a two-part manual setup process. See Consents and permissions for more information about manual setup steps.

This topic describes the steps to run a task to verify whether or not the Quest On Demand - Migration - Power BI enterprise application service principal is granted the necessary permissions to work with the Power BI application in the source and target tenants.

Starting the Test Power BI Connection Task

  1. Log in to Quest On Demand and choose an organization if you have multiple organizations.
  2. From the navigation pane, click Migration to open the My Projects list.
  3. Create a new project or open an existing project.
  4. Click the Power BI tile, or click Open from the Power BI tile to open the Power BI migration workspace.
  5. Open the Dashboard tab. Then click Connect to Power BI to start the Connect to Power BI Task wizard. Each step is described below:
  6. Prerequisite Setup

    This is an information step that tells you to verify that you have manually completed the setup steps described in the Consents and permissions topic. If you have not competed the manual setup steps, you must do it now.

  7. Schedule
    1. Choose from one of three options to schedule the task. The scheduler will be activated only after you complete the task wizard.
      • Run now - task runs immediately.
      • Run later - task must be started manually.
      • Schedule - task will be started at a future date and time entered in the corresponding calendar field.
    2. Click Next.
  8. Summary
    1. Verify the task specifications as described below:
      1. Name - name of the task. You can specify a custom name. Default name is Test Power BI Connection.
      2. Scheduled start - date and time when the task will start. Now indicates that the task will start immediately.
    2. Click Back to revise or review a previous step or click Finish to complete the task wizard and start the task as scheduled.

You can track its progress in the Tasks tab, view the summary on the Dashboard or monitor alerts and notifications in the Events tab.

Reviewing the Test Power BI Connection Task

  1. Open the Tasks tab.
  2. Select the Power BI task that you want to review.
  3. In the task details pane that opens, the information presented is as described below:
    1. Task Status - Status of the task.
    2. Type - Type of the task. The type is TestPowerBIConnection.
    3. Created - Date and time when the task was created.
    4. Modified - Date and time when the task was last updated.
    5. Last Operation - The action that was most recently performed in this task.
    6. Schedule - Date and time when the task started. Now indicates that the task started immediately after the task was created.
    7. Events (number) - Number indicates the count of events that the task encountered. The values indicate the type of the events and the event count for each type.

Reviewing the Test Power BI Connection Task Events

  1. Open the Tasks tab.
  2. Select the Test Power BI Connection task for which you want to review the events.
  3. In the task details pane that opens, click Events (number). The Events tab opens with a filtered list of events for the selected task.
  4. Select an event that you want to review. In the task details pane that opens, the information presented is as described below:
    1. Object - name of the Power BI object if applicable.
    2. Task - name of the task.
    3. Time - date and time when the event occurred.

Discovering Power BI Content

This topic describes the various ways you can discover Power BI content.

In this topic:

Prerequisites

  • The Test Power BI Connection task must be run before Discover All Contents can be processed.
  • The Test Power BI Connection task must successfully connect to the source tenant to process Discover All Contents.
  • The Test Power BI Connection task must successfully connect to both the source and target tenant to process migrations.

Considerations

We strongly recommend that you run only one discovery task at a time to avoid scheduling delays.

Discovering all contents

This is a unified approach which uses the Discover All Contents task to inspect the source tenant and discover all Power BI instances of Workspaces, Gateways and Connections.

NOTE: Discovering all contents is recommended as the first of all discovery tasks. This task will collect data for Workspaces, Gateways and Connections. This information will be indicated in the pre-migration report. To complete the pre-migration report, you must also run the Collect Statistics task.

Workspaces, Gateways and Connections can also be discovered separately using dedicated discovery tasks that are usually recommended for the discovery of newer Power BI objects, such as a refresh from the source tenant.

  1. Log in to Quest On Demand and choose an organization if you have set up multiple organizations.
  2. From the navigation pane, click Migration to open the My Projects list.
  3. Create a new project or open an existing project.
  4. From the Power BI tile on the project dashboard click Open. Then select the Dashboard tab.
  5. Click Discover All Contents in the Dashboard menu. The New Discover All Contents Task wizard starts. Each step is described below:
  6. Discovery Options
    1. Refresh user permissions - select this option to ensures that user permissions are up to date. Refreshing user permissions can be run once per hour. This option is helpful if you have added new user accounts to Power BI and the accounts have been discovered and matched with the On Demand Migration service.
    2. Click Next.
  7. Schedule
    1. Choose from one of three options to schedule the task. The scheduler will be activated after you complete the task wizard.
      • Run now - task runs immediately.
      • Run later - task must be started manually.
      • Schedule - task will be started at a future date and time entered in the corresponding calendar field.
    2. Click Next.
  8. Summary
    1. Verify the task specifications as described below:
      1. Name - name of the task. The default name is Discover All Contents. You can specify a custom name.
      2. Refresh user permissions - indicates whether or not the Refresh User Permissions option has been selected.
      3. Scheduled start - date and time when the task will start. Now indicates that the task will start immediately.
    2. Click Back to revise or review a previous step or click Finish to complete the task wizard and start the task as scheduled.
  9. When the task completes, the Workspaces, Gateways and Connections lists are updated.

Discovering Workspaces

This section describes the steps to discover Power BI Workspaces.

  1. Log in to Quest On Demand and choose an organization if you have set up multiple organizations.
  2. From the navigation pane, click Migration to open the My Projects list.
  3. Create a new project or open an existing project.
  4. From the Power BI tile on the project dashboard click Open. Then select the Workspaces tab.
  5. Click Discover in the List View menu. The New Discover Workspaces Task wizard starts.
  6. Discovery Options
    1. Refresh user permissions - select this option to ensures that user permissions are up to date. Refreshing user permissions can be run once per hour. This option is helpful if you have added new user accounts to Power BI and the accounts have been discovered and matched with the On Demand Migration service.
    2. Click Next.
  7. Schedule
    1. Choose from one of three options to schedule the task. The scheduler will be activated after you complete the task wizard.
      • Run now - task runs immediately.
      • Run later - task must be started manually.
      • Schedule - task will be started at a future date and time entered in the corresponding calendar field.
    2. Click Next.
  8. Summary
    1. Verify the task specifications as described below:
      1. Name - name of the task. The default name is Discover Workspaces. You can specify a custom name.
      2. Refresh user permissions - indicates whether or not the Refresh User Permissions option has been selected.
      3. Scheduled start - date and time when the task will start. Now indicates that the task will start immediately.
    2. Click Back to revise or review a previous step or click Finish to complete the task wizard and start the task as scheduled.
  9. When the task completes, the Workspaces list is updated.

Discovering Gateways

This section describes the steps to discover Power BI Gateways.

  1. Log in to Quest On Demand and choose an organization if you have set up multiple organizations.
  2. From the navigation pane, click Migration to open the My Projects list.
  3. Create a new project or open an existing project.
  4. From the Power BI tile on the project dashboard click Open. Then select the Gateways tab.
  5. Click Discover in the List View menu. The New Discover Gateways Task wizard starts.
  6. Discovery Options
    1. Refresh user permissions - select this option to ensures that user permissions are up to date. Refreshing user permissions can be run once per hour. This option is helpful if you have added new user accounts to Power BI and the accounts have been discovered and matched with the On Demand Migration service.
    2. Click Next.
  7. Schedule
    1. Choose from one of three options to schedule the task. The scheduler will be activated after you complete the task wizard.
      • Run now - task runs immediately.
      • Run later - task must be started manually.
      • Schedule - task will be started at a future date and time entered in the corresponding calendar field.
    2. Click Next.
  8. Summary
    1. Verify the task specifications as described below:
      1. Name - name of the task. The default name is Discover Gateways. You can specify a custom name.
      2. Refresh user permissions - indicates whether or not the Refresh User Permissions option has been selected.
      3. Scheduled start - date and time when the task will start. Now indicates that the task will start immediately.
    2. Click Back to revise or review a previous step or click Finish to complete the task wizard and start the task as scheduled.
  9. When the task completes, the Gateways list is updated.

Discovering Connections

This section describes the steps to discover Power BI Connections.

To start the Discover Connections Task:

  1. Log in to Quest On Demand and choose an organization if you have set up multiple organizations.
  2. From the navigation pane, click Migration to open the My Projects list.
  3. Create a new project or open an existing project.
  4. From the Power BI tile on the project dashboard click Open. Then select the Connections tab.
  5. Click Discover in the List View menu. The New Discover Connections Task wizard starts.
  6. Discovery Options
    1. Refresh user permissions - select this option to ensures that user permissions are up to date. Refreshing user permissions can be run once per hour. This option is helpful if you have added new user accounts to Power BI and the accounts have been discovered and matched with the On Demand Migration service.
    2. Click Next.
  7. Schedule
    1. Choose from one of three options to schedule the task. The scheduler will be activated after you complete the task wizard.
      • Run now - task runs immediately.
      • Run later - task must be started manually.
      • Schedule - task will be started at a future date and time entered in the corresponding calendar field.
    2. Click Next.
  8. Summary
    1. Verify the task specifications as described below:
      1. Name - name of the task. The default name is Discover Connections. You can specify a custom name.
      2. Refresh user permissions - indicates whether or not the Refresh User Permissions option has been selected.
      3. Scheduled start - date and time when the task will start. Now indicates that the task will start immediately.
    2. Click Back to revise or review a previous step or click Finish to complete the task wizard and start the task as scheduled.
  9. When the task completes, the Connections list is updated.

Reviewing Tasks

  1. Open the Tasks tab.
  2. Select the discovery task that you want to review.
  3. In the task details pane that opens, review the information presented
  4. From the task details pane, click Download Premigration Report. Download and save the ZIP file to a suitable folder, and extract the report.

Reviewing events for a Task

  1. Open the Tasks tab.
  2. Select the task that you want to review.
  3. In the task details pane that opens, click Events (number). The Events tab opens with a filtered list of events for the selected task.
  4. Select an event that you want to review. In the task details pane that opens, the information presented is as described below:
    1. Object - name of the Power BI object if applicable.
    2. Task - name of the task.
    3. Time - date and time when the event occurred.

Collecting Statistics

The Collect Statistics Task for Power BI conducts an assessment of all Power BI content types in the source tenant. It provides summarized and detailed premigration information about workspace types, gateways, semantic models, connections, reports and users.

In this topic:

Prerequisite

The Discover All Contents task must be run once before collecting statistics.

Starting a Collect Statistics Task

  1. Log in to Quest On Demand and choose an organization if you have multiple organizations.
  2. From the navigation pane, click Migration to open the My Projects list.
  3. Create a new project or open an existing project.
  4. Click the Power BI tile, or click Open from the Power BI tile to open the Power BI workspace.
  5. Select the Dashboard tab. Click Collect Statistics from the Actions menu. The New Collect Statistics Task wizard starts. Each step is described below:
  6. Schedule
    1. Choose from one of three options to schedule the task. The scheduler will be activated only after you complete the task wizard.
      • Run now - task runs immediately.
      • Run later - task must be started manually.
      • Schedule - task will be started at a future date and time entered in the corresponding calendar field.
    2. Click Next.
  7. Summary
    1. Verify the task specifications as described below:
      1. Name - name of the task. You can specify a custom name. Default name is Collect Statistics Task.
      2. Scheduled start - date and time when the task will start. Now indicates that the task will start immediately.
    2. Click Back to revise or review a previous step or click Finish to complete the task wizard and start the task as scheduled.

Reviewing the Collect Statistics Task

  1. Open the Tasks tab.
  2. Select the Collect Statistics task that you want to review.
  3. In the task details pane that opens, the information presented is as described below:
    1. Task Status - Indicates whether the task is completed.
    2. Type - Type of the task. The type is CollectStatistics.
    3. Created - Date and time when the task was created.
    4. Modified - Date and time when the task was last updated.
    5. Status - State of the task.
    6. Last Operation - The action that was most recently performed in this task.
    7. Schedule - Date and time when the task started. Now indicates that the task started immediately after the task was created.
    8. Events (number) - The number of events that the task encountered.
    9. From the task details pane, click Download Premigration Report. Download and save the ZIP file to a suitable folder, and extract the report.

Reviewing the events for the Collect Statistics Task

  1. Open the Tasks tab.
  2. Select the Collect Statistics task that you want to review.
  3. In the task details pane that opens, click Events (number). The Events tab opens with a filtered list of events for the selected task.
  4. Select an event that you want to review. In the task details pane that opens, the information presented is as described below:
    1. Object - name of the Power BI object if applicable.
    2. Task - name of the task.
    3. Time - date and time when the event occurred.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating