Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Im trying to read the SharePoint online excel spreadsheet data via Qlikview web files wizard we are getting "403 forbidden error"
Can you any one help me how can i extract the SharePoint online data to qlikview?
Thanks in advance,
Suresh.VV
Hi Suresh,
every share point excel file will be save in one common share drive, try to get the drive path.
In QV you can use the path instead of URL.
In share point
Library-> Open with Explorer
You will get the share drive path, there all your sharepoint files will besaved
Thank you Sasi
the bellow im copied my share point office 365 online spread sheet Url (the bellow link im trying to hit via web files)
Example Url:
can you please help me how to read online share point excel spread sheet data?
is there any other ways to extract ?
Thanks,
Suresh.VV
Hi Suresh,
If you want to load the share point online spreadsheet data.
Try to export the share point data to MS ACCESS DB with live connection, so that where ever there is new/edit of record in share point that will be automatically reflected into MS access.
So now try to load data from MS access to QV
Select the file type as xls or xlsx and try
Hi Vardhan,
Thank you
If possible can you give me the steps to implement,
You any document related to this if you have con you share me please.
Thanks,
Suresh.
Hi Avinash,
i have tried those all types bit its not work out, if i am going to choose xls are .xlsx format im getting bad zip file
Thanks,
Suresh.VV
you can follow any one the below link approach.
Reading Data from Sharepoint lists into QlikView
we are fetching data by created Access DB as bridge, by the time(when u r creating first time the source file "Select a folder and choose the option "Link to Data on the Sharepoint Site".")
HTH
Thank you Shiva,
i will try to implement
Thanks,
Suresh.VV