Import data from Sharepoint file

[path60449]

Good morning,

I am trying to get data from an excel file saved on Sharepoint, but I get the error message 'We couldn't authenticate with the credentials provided' when trying to connect anonymously.
I am using Office 365.

Does anyone know how to grant anonymous access?

Many thanks,

Paul