export/import using web link

[ghidalgo90]

Dear

Team

I am qlik user, one of our providers produce reports using qlik sense. Qlik give the option to produce "embed sheet"

I used excell that allow import data from web page to import above report using weblink . Using the follow steps::

1.Data / Import from web

2.. I this step I used the link provied by " "Embed sheet" / "iframe to embed in your web page"

3. Click in OK. Excell provide diferent ways to authenticate, I have tried all fo them, but not success. (I have user/pass of original web, where is produced the report)

I would like your help, to know how can I import the data in excell or power bi (the steps are the same).

Thanks for your support.

[abhijitnalekar]

Hi @ghidalgo90 ,

Like to ask you one doubt Are you looking to import chart in excel or data used in the chart?

[ghidalgo90]

I want import the data in excell.

Thanks

[abhijitnalekar]

Unfortunately, the link which you are using in the excel is actually a link of the visualization, not data that's why Excel is not able to authorize the same.

[ghidalgo90]

Hi

Can you let me know, in which way ca be generated the Link, to be readable from excell?

Thanks

[abhijitnalekar]

Hi @ghidalgo90 ,

There is no such direct link from which we can retrieve data from qliksense. but Yes we can achieve this using the Qliksense Capability API or the Engine API.

The below document surely helps you to understand the Qliksense API

http://help.qlik.com/en-US/sense-developer/3.2/Content/APIs-and-SDKs.htm