Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

sharepoint gateway error(not showing Oauth in Datasource Setting) and fails to refresh automatically

I have a SharePoint data source created with PBI desktop and choose authorization as an organizational account. Published the report in web service. The report does not get refreshed whenever there is a change in the share point excel. Scheduling report also throws an error because " credentials issue". Oauth2 is no longer showing in the Authentication method. How to manually refresh or configure schedule refresh for this report? It's a simple report and every time i have to manually refresh the PBI desktop report and publish to the web. Please provide your suggestions. 

Run & Enhance- refresh issue.jpg








Do you upload the Excel in on-premises SharePoint site or SharePoint online? If you use on-premises SharePoint site, please use Windows authentication in Power BI Desktop, and you would need to use gateway in Power BI Service to refresh the dataset.

If you use Sharepoint online, you can use  organizational account.


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I use a sharepoint and entered organizational credentials, hence I am still getting the same error. 


Please help. 


Thank you. 

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors