Could not obtain a WAC access token

[PVA1212]

I am trying to create a Workbook Session (Excel) in Qlik Sense Automation. I am using the template of Qlik: Qlik Sense straight table to an Excel sheet

An error ocures always: Could not obtain a WAC access token.

How can I solve this problem?

[AfeefaTk]

Hi @PVA1212 

We would require a few more details to troubleshoot the issue

Could you please share

1. Automation workspace
2. Automation run history of the failed run which can be retrieved using the Export Run Button

Please refer to the below article which might help you in getting the above details

https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-Qlik-Application-Automation/...

Thanks

[AfeefaTk]

Hi @PVA1212 

I did some research and found this

https://learn.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

https://learn.microsoft.com/en-us/answers/questions/346834/graph-api-sharepoint-postman-could-not-ob...

I am able to reproduce the issue when using Excel file in xls format

As mentioned in the above articles the Excel API doesn't support xls extension workbooks

So I think you are using the excel file in xls format and hence the Excel blocks are failing

Please try using excel file in xlsx format and see if that works

Thanks!

[PVA1212 · Accepted solution]

The solution is mentioned in the following article:

https://community.qlik.com/t5/Official-Support-Articles/quot-Create-Workbook-Session-quot-Automation...