Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saurabh_handa
Contributor III
Contributor III

Office 365 SharePoint connector SP Lists / Excel File queries

Hi Experts,

I have few queries related to new connector release by Qlik: Office 365 SP

  • When I try to reference an excel file hosted on SP, there’s no option to provide Worksheet name.(if workbook has multiple worksheets)   How can we refer data from a particular sheet? 

1.png

  • When I try to reference SP lists into Qlik, the query generates lot of additional columns along with the actual ones.

Also, some of the columns were renamed automatically. How can we use default columns/fields without being renamed?

rename.png

0 Replies