search cancel

Unable to load Odata using Tableau Desktop or Excel

book

Article ID: 254739

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

I am able to connect to Odata now using Excel and Tableau, but unable to load any tables using Tableau Desktop or Excel

Error Message: Failed to create extract. This data source requires an extract before you can start your analysis

Environment

Release :Clarity 16.0.3

Resolution

a) Login to Clarity

b) Reports& Jobs

c) Please run the below 3 jobs in sequence 

1) DWH (Full Load) Once completed successfully then run the 2nd Job

2) DWH Access Rights Job

3) Refresh Odata Model Job

d) Re-Launch Tableau/Excel

e) Connect to Odata