Migrate the data and reports from Oracle to Azure Sql server.

[kapil512]

HI,

Can anyone tell me, how to migrate the reports which is pointed to Oracle database to Azure Sql server database.

do we need create every report as new, or can we change directly to Azure Sql server.

Thanks,

Kapil

[v-sihou-msft · Accepted solution]

@kapil512

If the table structure is same, you just need to modify the Access Data function in your Power Query. 

Just go to "Advanced Editor" in Query Editor, change "Oracle.Databases()" into "Sql.Databases()", then you may "Edit Credential" to make it work. 

Regards,