Restore Power BI Data

    With AvePoint Cloud Backup, you can restore Power BI workspace permissions, reports, and datasets to their original location, to another location, or to a storage location. Note that when restoring to another location, reports and datasets can only be restored to another workspace. Additionally, only workspace-level permissions can be restored. Report-level permissions are not supported.

    *Note: If you want to restore the backup data to a storage location, you must have your own storage location configured. The default storage provided by AvePoint cannot be the destination of the restore.

    Complete the steps below to restore Power BI data:

    1. Navigate to the Restore > AvePoint Cloud Backup page, and then click the Power BI tile.

    2. Select the items that you want to restore. You can choose one of the following methods to find the data to restore.

    • Search mode – Define a Power BI workspace as the search scope and then use the properties to search for the items within the scope. Refer to the steps below:
    1. In the Name field, enter or select a Power BI workspace. The default search condition is to search the backup data within the last backup cycle.

    2. In the Backup time range field, the time range of the last backup cycle is displayed by default. Click the Calendar button to customize the backup time range. The start date must be earlier than the end date. You can click Reset if you want to reset the settings. Click OK to save your customization.

    3. Select Workspace or Report from the Level list for the items you want to search.

    4. Click Search to search the items according to the conditions you configured. The search conditions and the search results are displayed. The search results table will display a maximum of 2000 items. You can edit the search conditions and click Search to adjust the search results.

    5. Find and select the item you want to restore from the search results. In the Recovery point column, click the Calendar button to select a backup job that backed up this item at the status that you want to restore, and click Apply. Click the Restore button above the search result table to restore all selected items.

    6. Continue to step 3 to configure the Restore settings.

    • Calendar mode – Find a backup job that backed up the items at the time of the status you want to recover, and then search and select the items from the backup data of that backup job.
    1. In the calendar, all backup jobs of Power BI are displayed. You can select whether to display the finished with an exception or failed jobs in the calendar by selecting the Include jobs with only partial backup data option. Note that the data of these jobs may be incomplete. Hover over a backup job to show the backup job details.

    2. Select a backup job. All backup data, up to a maximum of 2000 items, are displayed in the table. You can select the Show data from this backup only option (historical data in this scope from previous backups not included) to only show the data backed up in the selected backup job.

    3. You can enter keywords to search the items, or you can click the backup data to browse the items you want to restore. Select the items you want to restore and then click the Restore button above the table to restore selected items.

    4. Continue to step 3 to configure the Restore settings.

    5. If necessary, you can enter a description for this restore job in the Description text box.

    6. Choose where to restore the backup data to.

    • Restore the data to its original location – Restore the backup data to where the data is backed up.

    • Restore the data to another location – Restore the backup data to another destination. Reports and datasets can only be restored to another workspace. Configure the following settings:

    • Select a restore destination – Select a container as the restore destination. You can enter keywords to search for the restore destination. The items that can be selected as the restore destination are listed under the Search box.

    • Action – Select how the backup data will be restored to the destination. Select Attach to restore the contents as children beneath the selected node, or select Merge to add the contents to the destination node. For example, you want to restore a folder to another folder. If you select Attach, the restored folder will become the subfolder of the destination folder; if you select Merge, the subfolders and contents of the restored folder rather than itself will directly become the subfolders and contents of the destination folder.

    • Restore the data to your storage – If you have selected the Viva Engage conversations or files, and you have the BYOS subscription, this option is available. You can restore the selected data to your storage.

    1. Select how to handle conflicts at the content level in the restore job.
    • Skip – The conflicting destination content will be retained in the destination, and the backup data of the conflicting content will not be restored.

    • Append the creation date to the report name– The conflicting destination content will be kept, and the backup data of the conflicting content will be added to the destination with a creation date suffix added to the report name.

    1. Turn on/off the switch to define whether to restore permissions. Only workspace-level permissions can be restored. Report-level permissions are not supported.

    2. Click Next to view the restore summary.

    3. Click Restore to restore the selected items.