Data Source Credentials Reset, Service/Desktop not Persisting Credential Changes

[Anonymous]

I use Power BI with a PostgreSQL 11 Azure DB, no gateway.

I published a report this morning to Power BI Service. I set a manual refresh for 10 am, and it promptly failed when the time came. I figured it was a data source credential error, so I navigated to the automatic refresh for the dataset and found the username and password were missing. I input the correct info for both fields and saved. I decided to double check they were saved correctly and refreshed the page. Opening up the credentials dialogue, they were missing again. So I tried again several times. None of them took.

I then opened the report in Desktop and attempted to edit the login info using the Data Source Options dialogue. I found that the entry in passsword box was not the same length as the actual password, but the length of the DB schema name (weird). I changed it to the real password, saved the change, closed the dialogue, and saved the report. I navigated back to make double sure I had done it correctly - it had reset itself back to the erroneous password. No amount of trying to change it fixed it.

Flustered, I opened another report to make a small change to some text and publish it while thinking of a solution, and was met with the same error as the automatic refresh failure (stream timed out) during the publish. So I checked its credentials in the Data Source Options and it had suffered the same fate as the one I had made this morning. This report has been on Schedule Refresh for some months without issue. I went to check on the Schedule Refresh credentials in Service for this report and the username/password are missing as well and unable to be corrected. No attempt to change them back has succeeded.

Has anyone encountered this error before? Is there a fix?

[v-janeyg-msft]

Hi, @Anonymous 

It’s my pleasure to answer for you.

Has the problem been solved? Regarding your description, I have a few questions to ask you in order to analyze the emergence of the problem.

One. Can your data on the desktop be refreshed normally? Is your gateway turned on when refreshing in the service?

Two. Refresh failure in PBI service usually has an error message. Can you provide a screenshot of the error message? You can view it under dataset>>setting>>refresh history.

Three. Are all datasets unable to refresh in PBI service? Or is it only the data source you mentioned?

Check whether the gateway is open, clear the browser cache and sign on again, or try to republish the desktop file to the service. Make sure the credentials are entered correctly.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @Anonymous 

This has not been an issue for me and when checking the Power BI Service for Gateway connections it all seems to be working fine.

Can you confirm that your browser is not removing the details in the page on the Power BI Service?