Forum Discussion
Your data source can't be refreshed because the credentials are invalid.
Dears,
for the first time I've created Pwoer BI report from sharepoint online list using power bi desktop, then publish it to power bi web
I'v downloaded personal gateway to keep the report updated and make scheduale refresh.
However, I've got this error after downloading the gateway
"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."
I couln't even make manual refresh
Any suggestions?
I found that my organization block the connection between thier Sharepoint and Power BI service for security reasons.
so it's nothing about Power BI.
15 Replies
- blopez11
Super User
There is not a lot of information here to go on regarding how things are setup (i.e. M code used to pull the list, etc.), however, when we've used sharepoint online, there is no need to use a gateway and the credentials provided are of type oath when configuring in the service
- Haya
Helper II
Thanks for the reply.
If there is no need to use gateway when I'm using SharePoint online list, How can I configure refresh schedual?
- blopez11
Super User
Use it as a web resource
The following link should be helpful, says one drive, but works for sharepoint as well
https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
- AnonymousNot applicable
HI Haya ,
Can you please provide more detail information to help us clarify your scenario? It is hard to troubleshoot without detail information:
How to Get Your Question Answered Quickly
Troubleshoot the on-premises data gateway#troubleshooting-tools
Regards,
Xiaoxin Sheng