Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
There is a proposed app which uses excel files as data source. The excel files are very large in size. Is this recommended? Can we support and maintain it in server without issues in future?
Is there any limit to the data volume when we use excel as source?
This is when you attach the file to the app. If you have a normal connection to the data this limitation does not apply.
Hi! Loading large Excel files should not be an issue for Qlik Sense. I have used some Excel files larger than 300MB without any problems. However, this has negative impact on the load time and I would recommend that you store the data as QVD files (especially useful if you have historical data that does not change) and use them as source.
Thanks. So I guess you loaded the excels through data load editor (script) and not data manager (drag and drop), correct?
I used the script, but both ways should be possible.
In Qlik help, I read that “The maximum total size of files attached to the app, including image files uploaded to the media library, is 200 MB.“
This is when you attach the file to the app. If you have a normal connection to the data this limitation does not apply.
Ok.
If your question is answered, please mark it as such to close the topic.