How to Load an Excel File on SharePoint in Qlik Cloud

[Troy_Raney]

Using Office 365 Sharepoint Connector (single file)

1. Identify base URL and site/Subsite Path. For example:
   • BaseURL: 
   • 
   • Site/subsite path: sites/SupportTrainingandEnablementDevelopmentArea
   • 
2. Configure the Connection
   • 
3. Click on the Authenticate button
4. Copy the Authentication code from the Authentication tab into the field and click 'Verify'
5. Proceed to the app by clicking on the Create and Analyze  button
6. Locate and select file in the folder
   • 
7. Select Table and Fields
   • 
8. Apply and necessary table associations
9. Load the data

Environment

• Qlik Cloud

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Click here to see the video transcript

@Bjorn_Wedbratt 

[FedericoDellAcqua]

Good morning Troy! 

Thank you very much for the detailed explanation! 

I'm implementing the connector but I have a question: is it possible to connect only to a specific subfolder using only the basic sharepoint connector? 

Thank you in advance! 

Federico.

[Sonja_Bauernfeind]

Hello @FedericoDellAcqua 

Please post your query in the Qlik Sense Connectivity and Data Prep forum. This will give you a broader audience and allow our active support agents to see your question.

All the best,
Sonja