How to correct invalid credentials in PowerBI online - Credentials provided invalid status code 400

[alanl_tef]

Apologies if the issue raised in my post has already been answered - I've tried several steps outlined in other posts, and my problem is still unresolved.

My main question is how to remove / update saved data source credentials.

Attempting to connect to a service "Planview Enterprise One - CTM" using PowerBI Online

Connections to this service works via PowerBI Desktop.

When connecting to this service via PowerBI online returns an error message - pasted below.  The main error is "The credentials provided for the Troux source are invalid"

The Connection is by providing an OData URL: - e.g. https://<site>/pvcloud.com

I have previously entered credentials that are incorrect, that appear to have been saved. i.e. all new attempts to connect use saved credentials

When the URL is entered, a message a "Please hold on while we check your credentials"

A Window appears with the message details copied below - "The credentials provided for Troux are invalid ..."

I cannot find a way to remove the incorrect credentials

In settings

- there is a Dashboard row for each failed attempt "Planview Enterprise One - CTM"  - there are no options to remove

- Datasets has a row for some failed attempts, when any one is selected non of the Settings options are displayed - e.g. on other connections I would see headings including "Data source credentials"

In PowerBI desktop I have cleared the credentials for this connection, logged out of both then reinstated the credentials in Desktop.

Error details from the PowerBI online message

We couldn't install Planview Enterprise One - CTM

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.

MessageThe credentials provided for the Troux source are invalid. (Source at <URL>.) Table: Qry_SoftwareProductVersionFact.

Activity IDbbfcfb9e-fa8f-4fea-ad96-43e68667533d

Correlation ID0a8d6b00-c78b-5ced-4f1e-9531029b1af4

Request IDa79b2461-e800-638d-4447-b89a994fa864

Status code400

TimeThu Apr 26 2018 07:52:50 GMT+0100 (GMT Daylight Time)

Version13.0.5027.204

Cluster URIhttps wabi-north-europe-redirect.analysis.windows.net

[v-yuezhe-msft]

@alanl_tef,

I  would recommend you clear the saved password, cache and cookies in your web browser and check if you can enter new data.

If the issue still persists, use in-private window of your browser to sign in Power BI Service.

Regards,
Lydia

 

[alanl_tef · Accepted solution]

Hi

Thank you for the feedback

- I had previously tried in private, use of another browser and accessing via different maching - that didn't seem to work

- I logged into PowerBI Desktop and cleared the credentials, and cache. 

- I then logged back into PowerBI online, retried the connection - entering the OData URL

- it still seemed to have saved credentials as I wasn't prompted for username or password.

- I then looked at the Datasets, and the "Dataset credentials" was accessible, so I edited the credentials to the correct username and OAuth token

I don't know if it was luck, in my timing - i.e. getting to the Datasets before the previous error was returne.

Anyway the above seems to now work.

That doesn't explain why the App install into PowerBI online doesn't "fail clean" - it leaves a copy of the App in the settings Dashboard list that can't be removed.  Nor does it confirm where the credentials are stored, and why they can't be accessed / updated.

Summary - use Desktop to remove the credentials and clear the cache, then navigate to "Datasource credentials" after entering the OData URL - and the "Datasource credentials" can be accessed.

Thanks again