Forum Discussion
Can't create deployment rule for Oracle data sources
Hi all,
I have a semantic model with 4 data source connections. Three of them connect to a Synapse SQL server and the other is a connection to an Oracle database. The model is built using Tabular Editor and uploaded to development workspaces designated in a deployment pipeline in Power BI service. I can assign deployment rules to the Synapse datas sources when promoting the model to the test workspace. However the Power BI service gives me an error when creating the deployment rule for the Oracle database. The error message PowerBI service gives me is "Rule property no longer exists". I reassigned the test workspace and taken over the ownership of the dataset but none of these worked. The server on development has the following format: dev_server_name:1521/dev_db . The aim of the deployment rule is to replace it with tst_server_name:1521/tst_db on test workspace.
Has anyone experience with Oracle data source deployment rules and got it to work? If so what did you do? Any pointers would be greately appreciated.
I haven't worked with Oracle as a data source, but one approach you could consider is using Power Query parameters to store the server and database names. Then reference those parameters in your Power Query connection.
When you deploy through Deployment Pipelines, you can simply update the parameter values for each environment (Dev, Test, Prod), and Power Query will use the appropriate server and database automatically.
3 Replies
I haven't worked with Oracle as a data source, but one approach you could consider is using Power Query parameters to store the server and database names. Then reference those parameters in your Power Query connection.
When you deploy through Deployment Pipelines, you can simply update the parameter values for each environment (Dev, Test, Prod), and Power Query will use the appropriate server and database automatically.
Hi vraagmaarraak,
Have you had a chance to review the solution shared by parry2k ? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi vraagmaarraak,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
