In our SharePoint 2013 on-premise environment, we have Approval workflows. Using SSRS reports, we display a report, who approved those tasks in a Grid view.

Now we are migrating our complete on-premise environment to SharePoint online, and two things i understood.

1) SharePoint online doesnt have SSRS reports. 2) When migrating content, Workflow history list, being a hidden list, will not be migrated.

I am hoping if there is any way at least to migrate the complete approval task list to SharePoint online list, we can use it a source to build reports from another system list power bi or tableau or is there any better solution?

This is only for existing data for reference purpose, no new records will be added to the workflow history list.

2 Answers 2


The task list should migrate, depending on what tool you are using. You can then use PowerBI for reporting. I'd suggest running a test migration of the task list to see how it will migrate over.


You could use the SharePoint Migration Tool to migrate the complete approval task list from SharePoint 2013 to SharePoint online.

You could download the SharePoint migration tool by the link.

More reference:

Using the SharePoint Migration Tool.

  • Can we migrate workflow history list as well? Commented Oct 25, 2019 at 13:33
  • No, because the workflow history list is hidden list, we cannot migrate the workflow history list.
    – Amy_MSFT
    Commented Oct 28, 2019 at 1:01
  • How about exporting that list content to excel and restoring it? Will it have any limitations? Commented Oct 28, 2019 at 1:25
  • Yes, you can export the list to excel, but you may encounter the some errors when you import the excel to SharePoint online
    – Amy_MSFT
    Commented Oct 28, 2019 at 7:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.