Read Sharepoint Excel (xls) from Qlikview

Anonymous — Thu, 15 Jan 2015 16:53:05 GMT

Hi,

I want to load the data from an excel file that resides in sharepoint. I tried

Load * From [http:Sharepointwebaddress/filename.xls] (biff, embedded labels, table is Sheet1$);

It is working fine from my local machine. But when i do the same from server machine, it is throwing a msg.

“You are not authorized to view this page You do not have permission to view this directory or page using the credentials that you supplied because your Web browser

is sending a WWW-Authenticate header field that the Web server is not configured to accept. Please try the following: Contact the Web site administrator

if you believe you should be able to view this directory or page. Click the Refresh button to try again with different credentials.

HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration. Internet Information Services (IIS) Technical Information (for support personnel)

Go to Microsoft Product Support Services and perform a title search for the words HTTP and 401. Open IIS Help, which is accessible in IIS Manager (inetmgr),

and search for topics titled About Security, Authentication,

and About Custom Error Messages.”

What might be the issue? Any suggestions?

Only thing i figured out is, when i open a browser in my machine and browse to sharepoint site, it is showing the data directly. But when i do the same in the server machine, it is asking me the login credentials. What is a good resolution here?

Re: Read Sharepoint Excel (xls) from Qlikview

Anonymous — Thu, 15 Jan 2015 19:06:04 GMT

Please read this thread:

How to load data from sharepoint which needs authentication?

Re: Read Sharepoint Excel (xls) from Qlikview

Wed, 22 Jul 2015 18:48:35 GMT

Hi did you find a resolution to this issue? I am having the same exact problem.

topic Re: Read Sharepoint Excel (xls) from Qlikview in QlikView

Read Sharepoint Excel (xls) from Qlikview

Re: Read Sharepoint Excel (xls) from Qlikview

Re: Read Sharepoint Excel (xls) from Qlikview