SharePoint Web Credentials Gateway error

[Anonymous]

Hi 

I have connected to Onprem ADFS enabled sharepoint folder using get data from web and organizational account, it has one excel file and no other data sources in my reprot. I have accessed this file get data and web,  path is  https://xxxxxxxxxxxxxxxxxxxxx.com/Book1.xlsx. I have established the connection in power BI Desktop and published the report. When i tried to enter web credentials in gate way getting error - Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at https://xxxxxxxxxxxxxxxxxxxxxxxxxxxBook1.xlsx.)

But the credentaisl are correct. How set up gateway for sharepoint.

[Anonymous]

Make sure you select "Windows" credentials and that the username you choose includes the domain.  If you username was a service account called "Service" on a domain called "ABC" the username would be 'ABC\Service' (without quotes).

If your SharePoint folder is open to 'everyone' and doesn't need credentials, select authentication type of 'Anonymous' instead.