In reports, you find a resource is missing in DWH_INV_SECURITY_V. As this user, you are able to see a certain project when you log in, but when you query this view in Power BI/custom reports, it does not come up. The impacted user is a participant on the project and is able to see the project as a participant.
The view has other users' data and the Load Data Warehouse Access Rights job has been run.
Release : Any
Component : CLARITY DATA WAREHOUSE
There is no Project View right granted. Project participants are able to see a project without Project View rights. But only Project View rights go to the DWH_INV_INVESTMENT_V table. This is by design, see: Able to view some projects you do not have rights to.
See also: Data Warehouse (DWH) known issues