Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kapil512
Helper II
Helper II

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

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

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@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, 

View solution in original post

1 REPLY 1
v-sihou-msft
Microsoft Employee
Microsoft Employee

@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, 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.