Power BI reports failed with Expression.Error: The key didn't match any rows in the table.

book

Article ID: 211506

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Power BI reports failed with below error

"Expression.Error: The key didn't match any rows in the table. Details: Key= Name=DWH_INV_PROJECT Signature=table Table=[Table]"

Also, when accessing Data Warehouse via Odata on desktop application tables dwh_inv_project and dwh_inv_investment are missing.

Environment

Release : 15.9.1

Component : OData

Resolution

  1. Flush PowerBI cache
  2. Run the full load Data Warehouse job
  3. Run the Data Warehouse Access Rights job
  4. Run Refresh Data Warehouse Odata Model job