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.
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
Solved! Go to 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
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |