Power BI reports displaying error / not refreshing after upgrade to 15.9.1

book

Article ID: 210626

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

I am getting following message in Power BI reports when refreshing them using PBI desktop application. This has started happening after Clarity upgraded to 15.9.1

"The column 'DWH_INV_INVESTMENT' of the table wasn't found.

Environment

Clarity SaaS Application/OData

Resolution

Perform the below steps:

  1. Flush Power BI Cache
  2. Run Load Data Warehouse (DWH) (Full)
  3. Run Load DWH Access Rights
  4. Run the Refresh OData Job

Additional Information

If one or more reports then fail with the below message connect to the report using a different Machine/Power BI desktop instance.
Expression.Error: The column 'DWH_RIM_CHANGE_REQUEST_LN' of the table wasn't found.
Details: DWH_RIM_CHANGE_REQUEST_LN
Following is the code snippet from advanced editor
#"Expanded DWH_RIM_CHANGE_REQUEST_LN" = Table.ExpandTableColumn(#"Merged Queries", "DWH_RIM_CHANGE_REQUEST_LN", {"CR_CATEGORY"}, {"DWH_RIM_CHANGE_REQUEST_LN.CR_CATEGORY"}),

Attachments