Web data source cannot get organizational Authentication method

[Anonymous]

Hello, I'm trying to get a schedule refresh out of an online data source (an Excel on a Sharepoint). But the credentials always fails, even though through Power BI Desktop i can make a manual refresh no problem. I can access and get the data no problem. So in theory, the automatic refresh should just be the same... but the Authentication method has no organization account. Basic fails, anonymous fails and OAuth2 does not work with this URL. So I'm stuck with a manual refresh. How can I force an authentication by Organizational Account method? Is there another way? The file does require an organization account, which I have and credentials are OK, otherwise I wouldn't be able to Get the data in the first place. 

Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at xxxxxx)

Status code: 400

[amitchandak]

@Anonymous , Try OAuth2,I think that should work for organization

[Anonymous]

Thank you for replying. As I stated in the post, I've tried but it says "The OAuth authentication method isn't supported for this data source." So I can't use it.