Forum Discussion
schedule refresh lost credentials
Hello,
Why is it that from time to time the Schedule Refresh setup losses some of the credentials? In spite no changes have occurred to them?
Hi Anonymous
From my experience this is if you save your Power BI Desktop into the Power BI Service, it will overwrite the current credentials. Which will mean that you will need to edit the credentials again.
AnonymousSRLyman Can you change it to use OAuth2 and enter the credetial for the dataset again? Please check if schedule refresh is successfull after you set the credential.
Best Regards,
Qiuyun Yu
16 Replies
I have been encountering the same issue. No matter how many times I set OAuth2, PowerBI automatically choses Anonymous. As a result, every automatic refresh fails. It would be nice if it could retain my account information. Is there a way to address this?
Hi Anonymous
From my experience this is if you save your Power BI Desktop into the Power BI Service, it will overwrite the current credentials. Which will mean that you will need to edit the credentials again.
GilbertQ, that is interesting.
You mean, whenever I publish the PBI Desktop to the PBIService the credentials need updating?
I could understand (sort of) why would it trigger such behaviour.
But in my case, the credentials got lost without me publishing it.
Still experiencing this problem where PBIRS scheduled refresh loses credentials when the report is edited and saved back to the server. With dozens of data sources this is a PITA, because the credentials for all of them have to be manually re-entered (or copy/pasted) into the PBIRS data sources settings (on the server) to re-enable scheduled refresh. Using the March 2018 versions. When will this be fixed?
AnonymousSRLyman Can you change it to use OAuth2 and enter the credetial for the dataset again? Please check if schedule refresh is successfull after you set the credential.
Best Regards,
Qiuyun Yuhi v-qiuyu-msft
It works after I enter the credentials again, yes.
my question is why does it looses the credentials in the first place?
Kind regards,
J
Hi Anonymous,
Please go to the Refresh History and find the record about that failed schedule refresh. Click the Show button to get detail error message, copy all this details and paste here. I will try to send your information internally to analyze the reason.
Best Regards,
Qiuyun Yu
Hello I am facing the same issue and have a complex report with lots of data source. Setting up credentials everytime I publish is not very intuitive and productive.
Is there a workaround or solution to this so that I don't have to Enter credentials to all sources again after each publish !
