Power BI reports displaying error message and not refreshing after Clarity SaaS upgrade to 15.9.1

book

Article ID: 210626

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Hi, I am getting following message in Power BI reports when I am refreshing them using PBI desktop application. This has started happening after PPM upgraded to 15.9.1 on March 13th.

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

Please help me fix this issue. 

Thank you.

 

Environment

Clarity SaaS Application/OData

Resolution

The steps below fix the missing column issue works, except with all but one report.
1) Flush Power BI Cache
2) Run Load DWH (Full)
3) Run Load DWH Access Rights
4) Run the Refresh OData Job

For the new error message:
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"}),

Resolution: Connect to the report using a different Machine/Power BI desktop instance.

Attachments