I am trying to automatically refresh my dataset through the power bi service. I want to refresh it through a sharepoint. However, I get the following message
|Time:||Mon Apr 30 2018 09:32:35 GMT+0100 (GMT Daylight Time)|
|Reports:||Invalid connection credentials.|
|Underlying error code:||-2147467259|
|Underlying error message:||The credentials provided for the SharePoint source are invalid.|
It appears you need to make sure the creditial are valid inside your Dataset settings. Go to your settings for the Dataset, you will see a menu for the creditials. It will usually tell you if you need to enter further creditials. If nothing found here then it looks like the gateway setup for this source is not authorize.
Make sure the service account or account you are using to refresh the data has access to the SharePoint site.