topic Re: How can I add a web file data source with authentication details? in Connectivity & Data Prep

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

rachel_delany — Mon, 19 Mar 2018 03:28:14 GMT

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.

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

Luka — Sun, 27 May 2018 11:55:35 GMT

Hi Rachel, any luck with the above?

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

Thanks

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

rachel_delany — Sun, 27 May 2018 22:14:14 GMT

Hi Nader,

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

Thanks

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

Luka — Mon, 28 May 2018 05:22:04 GMT

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

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

rachel_delany — Tue, 29 May 2018 22:16:46 GMT

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.