Problem with setting up credentials for SharePoint Access for a gateway

[gellmann01]

I am trying to set up a sharepoint site as a data source under a gateway that runs on my machine.

However, when I try to set up the windows authentication, I get an error for invalid credentials.

For me it is not very clear what kind of credentials you are supposed to fill in.

The credentials to access the sharepoint site?
The credentials to access my machine ( my username and password)?

Just to be clear, these two sets of credentials are not the same.

Edit: Might be relevant: if I try to connect to the same data source inside of Power BI Desktop, I don't need to input any credentials.

[v-cherch-msft]

Hi @gellmann01 

The Microsoft Credentials is to connect Sharepoint Online.For further,please refer to this post.If it is not your case,please have a look at below posts.

https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive

https://community.powerbi.com/t5/Service/Auomatic-Refresh-reports-successful-refresh-but-doesn-t-rea...

Regards,

[gellmann01]

Hi Cherie.

The link you posted set me in the right direction, I thank you.

I would like to ask one more question.

As far as I understand, since the data refresh for a cloud source (such a sharepoint source) is not linked to a gateway,
Any scheduled refresh will happen without any particular machines being turned on, right?

[v-cherch-msft]

Hi @gellmann01 

Correct.Kindly mark my answer as a solution if you feel that makes sense.

Regards,