QlikSense to MS SharePoint connection (Automation)

[arish_delon]

Hello Qlik Community,

Can you assist me with the following issue.

Business users are storing some data in MS SharePoint. I am trying connect to SharePoint from QlikSense.

I have service account. Its has office 365 license enabled. I can connect to the specific SharePoint using the Qlik Sense Service account manually. 

In REST connector i see SharePoint connector. When try this connector. I get the following error.

error = access denied
error_subcode = cancel
error_description = AADSTS65004: User declined to consent to access the app.

Please contact us at http://www.qlik.com/services/support if you are having trouble authenticating with a Connector.

I have raised a support ticket with Qlik. The case was closed with some links previous post.

My question is...does my service account in Qlik requires MS premium account? (This issue is Qlik issue because i can connect to SharePoint from VM where QS is installed. I want to automate the connection so every day or every week it will pick up the require data from SharePoint and update QS Report or Dashboard.