topic Re: Disable Import Excel Files in Qlik Sense in Management & Governance

Disable Import Excel Files in Qlik Sense

_Adam_ — Wed, 27 Dec 2023 11:42:07 GMT

Hi All,

I need advice regarding using Excel in Qlik.
Our Qlik Version is - August 2022 Patch 15

1. is it possible to disable the option Import data from excel ?
We want our users to get data only from databases and not files.
I have checked around for a while and saw this article:
https://community.qlik.com/t5/New-to-Qlik-Sense/Turn-off-CSV-uploads/td-p/1745777
On creation of new app it automatically shows a screen that you can drag and drop excel file and it loads its data,
When I disabled the SR 'File upload connection object' user received error message when he tried to load excel file on that screen. (Attached import screen & the error user receive).
BUT - user can still load excel file using the folder connection and insert the script in-line.. How can I block that option aswell ??

2. Is there a way for me to find out on which apps user is importing data from excel files ?

Any feedback will be much appreciated,
Thank you!
Adam,

Re: Disable Import Excel Files in Qlik Sense

anat — Wed, 27 Dec 2023 11:01:44 GMT

Can you look into below link if not yet explored

https://community.qlik.com/t5/New-to-Qlik-Sense/Remove-option-to-manually-add-data/td-p/2094339

Re: Disable Import Excel Files in Qlik Sense

_Adam_ — Wed, 27 Dec 2023 14:29:21 GMT

I dont know why the post is marked as solved, But I still need assist with it.
Please help.

Re: Disable Import Excel Files in Qlik Sense

_Adam_ — Mon, 08 Jan 2024 07:31:37 GMT

Anyone found solution for this?

How can I block the option to load excel files using folder connection from script in-line?

Also, is there's option to find out which apps using excel file as data source?

Thanks in advance!