Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to 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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 67 | |
| 45 | |
| 43 | |
| 36 | |
| 23 |
| User | Count |
|---|---|
| 191 | |
| 127 | |
| 106 | |
| 78 | |
| 53 |