Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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:
Hi @Justair07
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.
Best Regards
Maggie
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.