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
Component : CLARITY DATA WAREHOUSE
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.