Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
alanl_tef
New Member

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

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
1 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

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

@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

 

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

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors