After Deployment in PBI service from Dev to UAT (seperate schema/user and seperate db server). Fails

[XhevahirMehalla]

Hi 

I need Some input. 

I have some reports in PBI desktop using orcale Dev env (schema name = DEVUSER), published to PBI workspace DEV. 

I want to create deployment pipeline which deploy code from Dev workspace to UAT workspace.

UAT env  - the oracle db is on different server and a different user from Dev.

I created on-prem gateway and two connections one for DEV (different user and different oracle server) and I created another connection in PBI service for UAT which has different user and different server than DEV.

I created Rules where I can change the connection strings as below:

When I deploy reports and refresh the model I get this error message:

 

Something went wrongAn error occurred while processing the semantic model.

Please try again later or contact support. If you contact support, please provide these details.Hide details

• Data source error[ValidateMarkupTags]{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[ccon]Oracle: ORA-00942: table or view does not exist[/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"[ccon][ccon]10.110.32.173</ip>[/ccon]<ip><ip>10.110.0.0</ip></ip>:1521/prod_fcubs.proddb.spokeprdvcn.oraclevcn.com[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"[ccon]ORA-00942: table or view does not exist[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.NativeError","detail":{"type":1,"value":"942"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}
• Cluster URIWABI-WEST-EUROPE-G-PRIMARY-redirect.analysis.windows.net
• Activity ID0ae18f64-6920-e8d4-f328-862b477a981c
• Request ID1a74d201-24cf-c161-e0a3-c83d878a34bb
• Time2025-12-17 13:34:24Z

  What am I missing.

  The reports in UAT workspace still shows the data of Dev env.

  Please can you ehlp!

[MFelix]

Hi @XhevahirMehalla 

since this report is based on a local data and you are using a gateway to connect to your Oracle DB believe that the questions is around the connection to the new gateway connection.

Believe that your problem is around the user, you refer that you are using a different user? Is that different user on a different gateway or just a different user on the DB?

[XhevahirMehalla]

Thanks.

Dev env reside in a different oracle server.

UAT env reside in a different oracle server than DEV.

Both have different username and password.

Although the oracle db objects on both env are the same but the schemas (user) are different.

When I check the model in PBI service they look to point to a different Getway/Connection. Dev is connected to the right On-prem-connection (Dev) and for UAT is connecting to the right On-prem-connection (UAT) so this works. 

I get slightely different error now.  

Not sure what am I missing. 

Thanks for your help!

[MFelix]

Hi @XhevahirMehalla ,

Apologies for the following question, but I got some issues with similar things. Is the tables/views used in DEV environment already implemented in UAT enviroment of Oracle DB?

Asking this because it seems like the connection is passing but is not finding specific tables or views.

Did you test to update the UAT model in Power BI desktop?

[XhevahirMehalla]

Yes, they are the same tables/views. The names are not changing. The schema names/username and server name. Different env basically. 

Aftert I refresh the UAT model after has been deployed using the Deployment Pipeline it fails now. 

I think is the right approach. You have to refresh the model at the target in order to get the data from the UAT env.

Using the parameters in PBI desktop I created a parameter as SchemaName and created a List of Values (Dev username and UAT userName). I think am I doing the right thing.

Thanks

Xhev

[MFelix]

Hi @XhevahirMehalla,

I need to do some tests but the approach seems to be the correct one. when you go to the setting of the UAT do you have the Data Source Credentials correct or are they giving login error?

Asking this because the following dataset properties are also not copied during deployment:

• Role assignment

• Refresh schedule

• Data source credentials

• Query caching settings (can be inherited from the capacity)

• Endorsement settings

So you may need to go to the UAT Enviroment and check the credentials / gateway connection.

[XhevahirMehalla]

The UAT connection in PBI Service for UAT worksapce shows that is picking up the correct Connection. In PBI service I have two connections (Dev connection) and UAT connection and using the same on-premise Gateway and both of these are online. 

This the gateway and seem online:

and then is the DEV and UAT connection. Both connections using the same Gateway ( each having different user DEV=DevUser and UAT=UATUser and of course a different password.

On the Deployment pipeline I changed added rules by using SchemaName=UATUserName

What am I missing? 

I can see on the model on each workspace is showing that under the correct Connection Name (On-Prem Connection) so is picking up the correct db server but maybe the user is not picking up the user.

Does it have to be the same user?

I run out of options now.

Thanks

[MFelix]

Hi @XhevahirMehalla ,

Let me try on my side to check what can be happening. 

Just to check you have:

• Two Schemas DEV, UAT
• Same Tables
• Different users for each Schema
• Parameter to change the schema
• Pipeline between DEV and UAT
• Problem comes when you refresh the UAT environment

Is this correct?

[XhevahirMehalla]

My reply is  in orange: 

Just to check you have: 

• Two Schemas DEV, UAT: two seperate oracle database servers. Two seperate schemas or user name (Dev= DevUser=DevSchema) and (UAT=UATUser=UATSchema). 
• Same Tables: Yes both databases the same database objects and names are the same. DevUser.table_xyz and UATUser.table_xyz 
• Different users for each Schema: User and schema in Oracle is the same thing. Each Oracle DB server has different schema name/User. 
• Parameter to change the schema: yes, I added a parameter in PBI desktop as below:
• 
• Pipeline between DEV and UAT: yes , I created a pipeline between DEV and UAT workspace where I want the UAT workspace to be the target workspace as below:
• 
• Problem comes when you refresh the UAT environment: Correct, Once I deployment is succcessfull I go to the Model in UAT workspace and want to refresh to get the UAT data which should come from UAT oracle Database and that fails and reports itself shows data which from the  DEV env which is not correct. I will assign user to use UAT workspace. 

Maybe I am missing smth.

Maybe in PBI desktop I missing something but according to the docs and some other info got from you guys I was asked to setup Parameters as SchemaName. 

Thanks

Xhev

[XhevahirMehalla]

I think I found the issue. 

On PB desktop I had a mixed connection and I changed this for one table:

FROM:

let
Source = Oracle.Database("10.110.16.87:1521/nonprod_fcubs.nonproddb.spokenprdvcn.oraclevcn.com", [HierarchicalNavigation=true]),
JBDEV = Source{[Schema="JBDEV"]}[Data],
ICTM_ACC1 = JBDEV{[Name="ICTM_ACC"]}[Data]
in
ICTM_ACC1

TO:

let
Source = Oracle.Database("10.110.16.87:1521/nonprod_fcubs.nonproddb.spokenprdvcn.oraclevcn.com", [HierarchicalNavigation=true, Query="select * from ictm_acc"])
in
Source

Once I changed this then I can see the report is refreshed and I can see the data is flowing from DEV to UAT and I can see different output.

[MFelix · Accepted solution]

Hi @XhevahirMehalla 

Mixed connection give a lot of problems even without pipelines.

Glad you were able to figure out. Don't forget to Mark the correct answer só it can help others even if it is your own.