Forum Discussion

vraagmaarraak's avatar
vraagmaarraak
New Member
1 month ago
Solved

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...
Need Help
  • parry2k's avatar
    parry2k
    1 month ago

    vraagmaarraak

    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.

parry2k's avatar
parry2k
Super User
1 month ago

vraagmaarraak

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.