Document toolboxDocument toolbox

How to migrate created data sources between different instances of ServiceNow

NOTE: you need to be a system admin to perform the steps below.

If you are not a system admin but have PBI ADMIN or PBI EDITOR roles assigned, you can migrate created data sources manually. Please refer to the following part of the guide.

To migrate already created data sources between different instances of ServiceNow, e.g. from development to production, please do the following:

  1. In Filter Navigator find Local Update Sets

 

2. In Local Update Sets click New

 

3. Write a Name and click Submit and Make Current. Or Submit, then open the record in the Local Update Sets list and under the Related Links click Make This My Current Set

 

4. In Filter Navigator find Power BI Connector and navigate to Data Sources

 

5. Open the data source you’d like to migrate and under the Related Links click Add to Update Set.

Do the same for all the data sources that should be migrated

 

6. Get back to the Local Update Set created at the 3d step and change Update Set State to Complete. Click Update

 

7. Under the Related Links select EXPORT to XML

 

8. Switch to the different instance where migration should be done

9. In Filter Navigator find Retrieved Update Sets

 

10. At the very end find Related Links and click Import Update Set from XML

 

11. Chose the downloaded xml file and click Upload

 

12. Click on the uploaded Update Set (it should be in Loaded State)

 

 

13. Click the Preview Update Set button

 

14. If the preview is done successfully Commit Update Set should appear. Click it

 

 

Done! All the data sources should be migrated to a new instance!

 

How to migrate data sources manually

NOTE: you need to have PBI ADMIN or PBI EDITOR roles assigned

  1. In Filter Navigator find Power BI Connector and navigate to Data Sources

 

2. Click on Data Source that should be migrated

 

3. Copy the Export config from the Export config field. Other fields like Name, Description, etc should be also copied one by one

 

4. Switch to the different instance where migration should be done

5. In Filter Navigator find Power BI Connector and navigate to Data Sources

 

6. Click New

 

7. Paste the copied data and Submit

 

Done! All the data are copied into a new instance!