Migrating Power BI report from oracle db to Azure Sql db

[Anonymous]

Hi Gurus,

     I am creating a report with oracle db with 5 tables (Inner Join). Later we need to point the same report to Azure sql db with same tables names etc. Does this report works after pointing to Azure SQL?

     Do I face any issues or how to achieve it, kindly let me know.

Thanks,

Shamar

[v-piga-msft · Accepted solution]

Hi @Anonymous,

---

I am creating a report with oracle db with 5 tables (Inner Join). Later we need to point the same report to Azure sql db with same tables names etc. Does this report works after pointing to Azure SQL?

---

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. 

Best  Regards,

Cherry