SAP BW Datasource credentials error - Personal gateway

[Anonymous]

Hello,

I have a unusual problem for my published report. I have a personal gateway installed on my laptop, I'm on my companies VPN but can't set up my datasource credentials for SAP BW. I can set up my credentials for other on premise datasources like files saved locally on my hard drive but SAP BW just doesn;t want to take me account and passowrd.

The first thing I though of was obviousle that I'm adding my incorrect account and password, but login into SAP via the SAP logon works just fine, so the pass / acc is not the issue.

Any ideas why this is happening?

[braddo81]

we have the same problem.

we are using PBI on prem, no gateway connection 

logging into BW works

PBI client connects to datasource and report has data

publish report, and try add creds to the datasource - error

[V-pazhen-msft]

@Anonymous 

What is the error message when you enter your credential? Try the credentials in both desktop(datasources setting) and service(Dataset edit credential). 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello,

The errors is as follows:

Failed to update data source credentials: The credentials provided for the SapBusinessWarehouse source are invalid.

But I am 100% sure the credentials are correct.

Also, in desktop the refresh works.

Also, the personal gateway is working for other sources ( like files saved locally).

[grubpot]

I have the same issue.

Fine to connect to network drives & SQL, but Power BI will not accept credentials for BW.

Failed to update data source credentials: The credentials provided for the SapBusinessWarehouse source are invalid. (Source at cibw3/85/100.)

However the credentials are correct, and work for Power BI desktop.

[Anonymous]

Glad to hear I'm not the only one...

I checked with an IT guy in my company and he concluded that it is not an issue of the gateway / power bi service or with the credentials.

He says the issue is some firewall most likely blocking my machine conecting with power bi service...

[grubpot]

Hi,

Thanks for that! It gives me somewhere to look.

Not sure I will be allowed to bypass any default company firewall settings.. but I can ask!!

[PMpm]

@grubpot Did you found a solution? I am experiencing the same error message with credentials.