ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ODATA Datawarehouse table extract issue after Tableau upgrade


Article ID: 225655


Updated On:


Clarity PPM SaaS


We are trying to connect to Clarity Datawarehouse tables through ODATA connection and we are not able to extract data from few tables. There is a server error that pops up as below.

The tables differ from region to region. For example the DWH_INV_INVESTMENT table is not accessible in Dev region but works fine in PROD, where as the DWH_INV_STATUS_REPORT is not accessible in PROD but accessible in Dev.

Tableau failed to create an extract. This data source requires an extract before you can start your analysis.

DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)




Release : 15.9.3



Tableau 2021.1.3

This URL contains some OData specific strings, and research on the '$skiptoken' value led to an SAP thread on OData pagination:
The pertinent information comes from the bottom post:
You can use the recent snapshot based pagination and loop over $skiptoken to get all the remaining pages

"excp-msg":"Unable to access OData

Workaround: filter upfront or do excel first and load to Tableau.