Solved: Migrate the data and reports from Oracle to Azure ...

kapil512 · ‎11-20-2017

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 · ‎11-21-2017

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,

v-sihou-msft · ‎11-21-2017

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,

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