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.
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.