Change data source from SAP BW/4HANA Application Server to BW/4HANA Message Server

[Anonymous]

Hi,

In my current project, we have 3 BW/4HANA environments DEV (Application Server), TEST (Message Server) and PRODUCTION (Message Server).

I have created a PBI report using the latest version of Desktop and Implementation 2.0 via Direct Query in DEV. The report needs to be validated in TEST before deployment to PRODUCTION.

In Data Source Settings, I can only change Server, system number and client but not change the source from Application Server to Message Server. 

I have tried to publish the report and change the connection via gateway but I am unable to change in PBI service either.

Please can you help?

Thanks,

AbdulRafay

[v-easonf-msft]

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If it is, you can add your reply as Answered to close this thread.

Best Regards,
Community Support Team _ Eason

[Anonymous · Accepted solution]

Hi @v-easonf-msft 

The issue has not been resolved. It is because only the source can be changed and not the connector type. If I create a report based on Application Server there is no option to change it to Message Server and vice-versa.

It is best to develop using a data source as it supposed to be in the production environment. We can use this as a solution.

Regards,

@Anonymous 

[v-easonf-msft]

Hi , @Anonymous 

Data source settings can only modify some established data source credentials, but not the connector type.

It is likely that  you need to replace the connector function in the advanced editor.

But we haven't tested the source  and can't know how the two converted queries are changed in the advanced editor.

If the data sources are similar, the connector can be replaced, but the conversion  is not guaranteed. Try to backup a pbix file and convert to see if there will be an error.

Sorry we cannot provide an effective solution currently, please kindly raise it to the support team for better advice if your are a pro user.Thanks a lot!
https://powerbi.microsoft.com/en-us/support/ 

Best Regards,
Community Support Team _ Eason