Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.