Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

"Failed to add data" - folder connection issue

Hey Guys! I'm new with Qlik products and I struggle with a simple task when I need to load data from xlsx file to Qlik Desktop.

I've created an app in desktop hub and folder connection. Everything is ok when I upload the file

2016-12-05_1421.png

But when I click "prepare data" here comes the error

2016-12-05_1422.png

Connection established in the standart folder C:\Users\username\Documents\Qlik\Sense\Apps

I've tried to connect another folder on drive D: but no results

Maybe the problem relates with user roles, because I'm not admin and can't change it. Please assist.

Tags (1)
6 Replies
fgillen1
New Contributor III

Re: "Failed to add data" - folder connection issue

I have the same issue..tried to import from Oracle connection as well but with no luck! Any help greatly appreciated.

rittermd
Honored Contributor

Re: "Failed to add data" - folder connection issue

Have you tried just dragging the excel file onto the app when you create it instead of creating a connection.  Let QS do the work.

rittermd
Honored Contributor

Re: "Failed to add data" - folder connection issue

I don't use Oracle.  But have set up many data connections with SQL.

Have you confirmed that the connection actually works?  If it does work then at what point are you having a problem?

I still do it the old way.  I typically don't use the Data Manager.  But if you pick The data load editor instead of 'Add Data' then when that opens you should see your Oracle data connection on the right side.  There should be a button to Select Data.  Click on that and then you should be able to see the tables in your database.  If you get this far then the connection itself is working.

Select any table.

Then select insert script.  The code should now show up in your script editor. 

Click on Load Data in top right corner.

If everything is setup correctly your data should load and then you can open the App and build some visualizations.

Not applicable

Re: "Failed to add data" - folder connection issue

I have the same issue too. Tried to import excel document from local folder.

fgillen1
New Contributor III

Re: "Failed to add data" - folder connection issue

Sorry Mark,

Sorry for the delayed reply...I have tried the above. It seems the only way round is to create a new app and try and add all tables in at once.

Finbar

charleschannn
New Contributor

Re: "Failed to add data" - folder connection issue

Not sure if the solution is still relevant but take a look at your headers in 'Data Load Editor'. Perhaps on your second load you may have changed the headers' names and QS is unable to recognize the different names. I changed mine accordingly and subsequent datasheets loaded proper. Hope it helps, cheers.