Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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 D...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

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