Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
To separate dev and production environments, I created a dev computer (which can only connect do dev database) and a gateway computer (which can connect to production database). But when I publish an Oracle Direct Query data source, there hasn't any option to choose Gateway to connect to production database.
So, is there any way to choose Gateway for Oracle Direct Query? Is it a bug or a missing feature?
PS: I can choose gateway fine with Oracle Import connections
Solved! Go to Solution.
@Anonymous You would need to change the PBIX file connection in the Desktop and re-deploy the report. It would pick up the new production connection on the other gateway. There is no way to swap data sources via the Service.
@Anonymous You would need to change the PBIX file connection in the Desktop and re-deploy the report. It would pick up the new production connection on the other gateway. There is no way to swap data sources via the Service.