SaaS - After migration to new Data Warehouse Odata service it is much slower to pull data for larger tables.

Products

• Clarity PPM SaaS

Issue/Introduction

Since Odata migration Power BI Odata is having issues with refreshing the data for larger tables and running into 2 hour timeout limit.

Steps to Reproduce: 

1. Using Power BI setup connection to Odata endpoint for the environment.
2. Attempt to refresh some of the larger tables (could very for each customer).
Examples:
dwh_tme_entry
dwh_tme_entry_facts
dwh_tme_sheet dts
DWH_TME_SHEET_LN
DWH_TME_ENTRY_LN
3. It will take long time to refresh and depending on the size of the table will run into timeout error of 2 hours.

Expected Results: it should take approximately similar time it took in the previous solution.

Actual Results: it is hitting a timeout when attempting to refresh the model.

 

Environment

Clarity 16.3.1

OData Version/Build    2.0.0.94

 

Cause

DE169043

Resolution

Fixed in Data Warehouse OData version: 2.0.3.4_2.0.2.6.

Workaround: Attempt incremental refreshes.