I have a dataset that I want to add to my gateway so I can schedule data refreshes. The data is in a Excel file on Sharepoint. Here is what I have tried so far:
Checked the "allow users's cloud data..." box
I was expecting an OAuth2 authentication method here but I don't see that option:
Do you connect to Sharepoint source online or on premise?
As tested, If it is online list, after publish report from Power BI Desktop to Service, go to "Setting"->select this dataset->scedule refresh->edit credential
After sign in with my organizational account which is both used for Power BI Service and Sharepoint online list.
I can refresh succefully.
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-juanli-msft I'm connecting to the Sharepoint Source Online. I did exactly as you show in your picture and it is succesful in configuring my credentials. My issues is when I try to add a new data source to my Gateway, I get this error: