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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
cnschulz
Helper IV
Helper IV

Authentication credentials not persisting

Hi, Im running the August 2018 PBIRS and having trouble with many reports not saving credentials. I have reports with two SQL server connections and one Excel connection via our HP/TRIM data store.  All connections use windows login credentials with the same username and password (This user has changed recently which may be important). The steps to reporoduce this erroe are as follows:

 

1: Observe the error that the username/password is incorrect.

2: Re-enter the username/password for the erroneous data source and press Test (=success)

3: Press save and manuallt run the scheduled refresh.

4: Observe that another (different) connection is reporting that user/pass is incorrect

5: Goto 2 - stay in this loop forever.

 

I *think* somewhere the old passwords are getting cached but I cant see how.

 

Has anyone encountered this? have a solution?

 

 

4 REPLIES 4
PedroSimao00
Frequent Visitor

I have a similar issue, everytime my password is updated (which is every 3 months due to company policy) and I try to refresh the data in my PowerBI or Excel Power Query, the connections to any Sharepoint folder get a Credentials error. When I try to update the password it doesn't seem to register and it gets stuck in a loop.

Maaike_V
Frequent Visitor

Hi,

 

I have the same issue.

4 connections, all test ok, but on refresh one will have authentication errors ( a different one every time). Go into credentials, update them. Test all connections, all ok, on refresh ..... 

 

The connections are 2 SQL, and 2 Oracle.

Hi,

 

I have experienced a similar issue to this with multiple connections... In our case, when updating the credentials for a single connection and hitting save, it would cause issues for the other connections - this would be verified by immediately testing all connections after the update - some would fail.

 

To work around the issue I had to to enter the credentials for all connections of the report before hitting save - even if they were not edited.

 

Not sure if this is relevant to you.

 

 

Hi,

 

Thanx, I found out something similar, I need to hit SAVE after updating a connection. Not updating more than 1 at a time seems to work. 

 

Maaike

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors