Issue connecting to Power BI

Products

• Clarity PPM SaaS

Issue/Introduction

We are experiencing the random issue with loading data from DWH_INV_INVESTMENTS to POWERBI

Rebuilding DWH by Load Warehouse (Full Data) didn't help.

Connect the PowerBI desktop by ODATA to Clarity PROD DWH.

Load the data from DWH_INV_INVESTMENT. 

Resolution

Please perform the following in sequence

- Run the Full Load of DWH (JOB)

- Run the Load DWH Access Rights (JOB)

- Run ODATA Refresh Model (JOB)

- Connect to Power BI and then fetch the data.