Scheduled refresh

[nsundareswaran]

Trying to set auto refresh for the dashboard created with DataSource using excel file located in the share point folder through Get data - Web option. While setting Data source credentials, authentication option as Oauth and privacy level as Organizational, i am getting below error:

"The OAuth authentication method isn't supported for this data source. Contact your admin."
Have tried changing the Authentication menthod, privacy level, none of them works.

Can someone help me here.

[collinq]

Hi @nsundareswaran ,

I have found a couple potential solutions.  Here is a support article:  Troubleshooting OData sign-in errors in Power BI Desktop - Power BI | Microsoft Learn 

This is a great explanation of how this works: Quick Tips: Connecting to Excel Files Stored in SharePoint Online from Power BI Desktop - BI Insight