Connecting to Qlikview data

[kibanjain]

Hi there,

Has anyone had experience connecting Qlikview data directly to PowerBI?

Currently have a report accessing multiple data.

30+ users are exporting their sales from Qlikview and are entering it to a import form on excel with macros. Would like to automate this process and connect directly to the data in Qlikview.

Is there a way to connect to Qlikview as there is no connector option under get data?

Thanks!!! If not, has anyone found a work around?

[marcus_sommer · Accepted solution]

You could create an appropriate data-structure within the script and just storing it as csv-file within the target-folder(s). And then could PowerBI directly grab these data.

Beside this you may reverse your approach and enrich the data within QlikView so that users could do their analysis there.

- Marcus

[Chip_Matejowsky · Accepted solution]

I'm fairly certain you could use REST API to connect between the two products.

[tomdegroot]

I am quite interested in making a REST API connection from Excel to Qlik Cloud. My use case is that end users have to input data and I want them to be able to use Excel for that. Refreshable Qlik Cloud data should be available for the end users to do calculations on in Excel. I tried setting up a REST API connection but I get stuck with the authentication (I think). Any experience?

[tomdegroot]

Never mind my question about user input in Excel, I am switching to user input in Qlik Cloud.