article Tabular Reporting OAUTH Error Status 400 resolution in Official Support Articles

Tabular Reporting OAUTH Error Status 400 resolution

Frank_S — Fri, 07 Mar 2025 19:13:17 GMT

This article describes how to resolve the OAUTH Error Status 400 error preventing successful configuration and download capability of the MS Office addin manifest necessary for Tabular Reporting.

{"errors":[{"title":"Invalid redirect_uri","detail":"redirect_uri is not registered","code":"OAUTH-1","status":"400"}],"traceId":"0000000000000000xxxxxxxxxxxxxxxx"}

Resolution

An OAuth client configuration is required to install the Qlik add-in for Microsoft Excel. The add-in is used by report developers to prepare report templates which control output of tabular reports from the Qlik Sense app.

Review or re-do the steps documented in Creating an OAuth client for the Qlik add-in for Microsoft Excel.

Verify you have included the user_default scope.

Example of a working OAUTH configuration:

Cause

The OAUTH configuration was not set correctly, such as missing the user_default scope, missing an additional allowed origin (alias address) or not setting up the redirect link.

Re: Tabular Reporting OAUTH Error Status 400 resolution

ramonneto — Mon, 25 Mar 2024 14:58:46 GMT

Prezado, revisei TODAS as etapas de configuração e sigo com o mesmo problema apontado inicialmente:

Importante destacar que, usando o Excel Web versão, não tenho o mesmo problema na autenticação. Através do Excel Web a autenticação é feita normalmente.

Re: Tabular Reporting OAUTH Error Status 400 resolution

Frank_S — Tue, 26 Mar 2024 19:41:27 GMT

If you have configured oAuth correctly and

1. It works for you Web version of MS office 365

2. It does not work for supported versions of MS office excel installed on your desktop.

Please check that your MS office excel is a supported version. If supported version of desktop MS office excel and you still see the error, please start a support case.

Microsoft Excel version requirements

Kind regards...

Re: Tabular Reporting OAUTH Error Status 400 resolution

ramonneto — Mon, 13 May 2024 14:38:48 GMT

Prezados, ou responder em português para ser mais assertivo e claro em como resolvemos o problema:
1. Removemos todos os testes de manifesto implantados e também os removemos da configuração admin feita na MS, incluindo a configuração OAuth no Qlik Console de Gerenciamento.
2. No MS Excel, em: Opções -> Central de Confiabilidade -> Configurações da Central de Confiabilidade -> Catálogos de Suplementos Confiáveis ->> Marcar a opção "Dá proxima vez que o Office iniciar, limpe cache de todos os suplementos web previamente iniciados"

3. Refazer o passo a passo conforme padrão informado pela Qlik.

Dessa forma o serviço funcionou normalmente em todas as opções de uso do Excel.
Obrigado pelo retorno.

Re: Tabular Reporting OAUTH Error Status 400 resolution

Frank_S — Mon, 13 May 2024 14:49:15 GMT

Please start a new community forum post for your question here.

Qlik Reporting Service | Qlik Community

Kind regards...

article Tabular Reporting OAUTH Error Status 400 resolution in Official Support Articles

Tabular Reporting OAUTH Error Status 400 resolution

Resolution

Cause

Related Content

Environment

Re: Tabular Reporting OAUTH Error Status 400 resolution

Re: Tabular Reporting OAUTH Error Status 400 resolution

Re: Tabular Reporting OAUTH Error Status 400 resolution

Re: Tabular Reporting OAUTH Error Status 400 resolution