Forum Discussion
Refresh fail - "Credential are required..."
Community ChampionAnonymous - OK, I just tried this. I created a brand new Excel 2013 file. I connected to my SharePoint Online instance and loaded a list into the data model, only creating a connection. Save the file locally. Then I uploaded to Power BI using Get Data | Local File. It loaded up successfully.
Now, I went in and looked at Schedule Refresh. It told me that my credentials were invalid. So, I hit the Edit credentials link and logged on and updated my credentials. Next I turned on refresh. Then, I hit "Refresh Now". That succeeded but when I went back into Schedule Refresh, it initially told me that my credentials were invalid. However right next to the "Edit credentials" link was a spinning icon and it eventually (5-10 seconds) removed the yellow error message automatically.
Now, all this being said, what I note that is different about my setup and yours is that I am logged on as myself to both Power BI, SharePoint Online as well as my gateway (Personal gateway). So, that *may* have something to do with it. I would use the smiley icon in the Service to send a "frowny face" to support along with a screen shot of what you are seeing and see if perhaps they have an answer for you.
Let me know if this generally mimics your environment (other than you have a different user for SharePoint Online) or if I got something wrong in my test.
This is a screen shoot
!
For security i hide many fields, and the interface is in spanish (my native language), if you don't understand a word, google translate help you, its helps me ;)
This rare case, everything seems fine! The gateway is on line, the credentials is ok
This is the screen shoot of the error:
hey Greg_Deckler its works, if you ask me how? i dont know! :manlol: i change the check of the one drive update, and after minutes the warning icon change, and the refresh success :)
Now, i have other problem :D, i try to resolve before post here