I'm currently trying to store a table on my Drive folder using Qlik View's Data Load Editor. I manage to create a successful connection with my Drive, loading data works fine, the problem shows up when I try to store a table in my Drive. I've tried storing it as both .csv and .qvd, none of which are working for me.
The error says the following:
Cannot open file: 'lib://Google_Drive - myuser@myaddress.com (connection_name)/filename.csv' (Native Path: qfilestream://filename.csv System error: ***)
The line of code responsible for the error is the following:
STORE filename INTO [lib://Google_Drive - myuser@myaddress.com (connection_name)/filename.csv](txt)
If you are using the Google Drive connector in Qlik Sense Enterprise on Windows, you may be out of luck. According to the documentation, storing data through this connector only works in SaaS for some reason. "The data storage feature is currently only available on Qlik Sense SaaS."
Could that be your issue?
If you're using Qlik Cloud, I just want to check with you: is the table you are trying to store named "filename"?
