Problem to refresh data online with Excel files on Sharepoint

[Anonymous]

I am experiencing an issue in PowerBI online with the refresh of data stored in Excel filesm on my organization's sharepoint server).

When setting up the credentials, using Windows authentification, I get the following error message. I get the same message using Anomymous or Basic. 

The odd thing about it is that the data refreshes fine online on PowerBi Desktop.

The Excel files are connected as Web Source in PowerBi Desktop. With Windows authentification method.

[v-yuezhe-msft]

@Anonymous ,

Do you use SharePoint online or on-premises SharePoint? If you connect to SharePoint online excel, please use organizational account in Power BI Desktop and use OAuth authentication in Power BI Service.

Regards,
Lydia

[Anonymous]

Hello,

I use On premises sharepoint. This solution does not work.

Best

Sebastien

[v-yuezhe-msft]

@Anonymous ,

Do you use personal mode gateway or on-premises gateway?

Regards,
Lydia