topic Re: Loading data from sharepoint file through QMC, failed with error: Error: Cannot read BIFF file in QlikView

Loading data from sharepoint file through QMC, failed with error: Error: Cannot read BIFF file

kaicpa2 — Thu, 06 Feb 2014 19:27:50 GMT

Hello all

I have an issue for which I hope you can give me direction:

I have an excel file (xls) on a sharepoit (version 10) and:

- when I run the reloald from the desktop, the updated goes fine

- when running the reload from the QMC it fails and reading the Log file, the error is "Error: Cannot read BIFF file"

Let me say:

- The User Qlikview running the service has full access to the sharepoint

- when running the report from the Desktop with the same user (the one that run the QMC service) it works like a charm

- with previous version of the Sharepoint there were no issue like this

Thanks for you help

Carlo

whiteline — Thu, 06 Feb 2014 20:14:00 GMT

Hi.

It seems that QlikView User needs to login to have the access.

Thu, 11 May 2017 21:39:19 GMT

You have to conect directly to each excel file using driver.

I was getting the same issue and i solved with attachment file example.

I hope it help you.