How can I add a web file data source with authentication details?

[rachel_delany]

Does anyone know how I can add a web file data source to Qlik Sense with my user authenticaiton details?

When I try to add the data source in Qlik Sense it provides the error: 'Access is denied: the authentication has failed or has not been provided.'

However, I cannot find anywhere to input authentication details.

[Luka]

Hi Rachel, any luck with the above?

Doesn't seem like anyone else is talking about this issue in the community

Thanks

[rachel_delany · Accepted solution]

Hi Nader,

I ended up using a REST connection which worked well for what I needed.

Thanks

[Luka]

Thank you Rachel for replying back so quickly.

I do use the REST Connection to pull data from SharePoint Lists.

Were you able by any chance to pull data from an actual excel file in a SharePoint document library?

Thanks again

EDIT: Okay so i was able to pull back only a "CSV" file from SharePoint.

Still would rather pull an XLSX file if possible

[rachel_delany]

The only way I could pull data from an Excel file in SharePoint was through a Web File connection, however I couldn't work out a way for the server to be able to refresh. If you are able to get your server service account access to the file in SharePoint it should work.