SAP BW connectivity issue

[jansb000]

I have been using SAP BW as a datasource without problems. Now I have to test several new user accounts to check if their authorization settings are correct. However I can't find a way to reset my own account settings. As soon as I have entered de BW server name, system number etc I get the list of cubes. Power BI assumes that I always want to login with my initial account.

Question: How can I reset this so I am able to login with another account?

[Anonymous]

Hi @jansb000,

I am not familiar with SAP BW, however, based on this  blog, you should be able to change account setting in Power BI Desktop.

Please go to Files>Options and settings>Data source settings in Power BI Desktop, search for your SAP BW data source, click Edit Permissions in the following similar screenshot, click the Edit button on the Credentials screen and check if you can change the user name and password.


In addition, make sure that your Basis Administrator has disabled the Single Sign On option for your user account and enabled the Logon using Username/Password option.

Thanks,
Lydia Zhang