Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have the Qlik Sense Enterprise 14.5.4 (February 2021) and the QlikWebConnectorsJune2021 installed. We are able to connect to CSV file and fetch the data on Qlik Sense. But we are not able to connect to the xlsx file. While making a data connection using Web file on Qlik Sense, we are getting the below error -
We have the required permissions to access the file.
Screenshot of the Sample file which we have used (test.xlsx)
On the Amazon S3 connector , when we save and run the table, the data preview is also displayed as shown in the screenshot -
Could you please provide answers for the below queries -
1. Are there any limitations for the Amazon S3 Connector?
2. Amazon S3 Connector works for which file extensions?
3. Is there anything which we are missing in building the connection with xlsx files.
Please guide us on the same and fetching the data from xlsx files from S3 buckets to Qlik sense.
Thanks
Hi @ACN_DASH_QLIK ,
Yes, I had same issue.
Did you try to use "SaveRawObjectToDisk" then read the data from the local destination.
Remember to update the tag <FileSystemAccessAllowedPaths> in "deploy.config" before saving to disk
ex: <FileSystemAccessAllowedPaths>c:\Temp</FileSystemAccessAllowedPaths>
Hi Joseph,
Yes, I tried using the 'SaveRawObjectToDisk' after updating the mentioned tag in the deploy.config. The error message I am getting is -Access to path c:\WebConnectorTemp is denied.
here C:\WebConnectorTemp is the path where I want the files to be saved.
Could you please assist me with the solution on this issue?
Thanks