You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.)The mod
Posted: Wed Aug 17, 2022 7:02 am
You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.)The model has the following relationships:-> Store to District based on DistrictIDSales to Store based on LocationID-> Sales to Date based on PeriodID-> Sales to Item based on ItemIDYou configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.When the district managers view the Store by Items report, they see items for all the stores.You need to ensure that the district managers can see items for the stores they manage only.How should you configure the relationship from Sales to Item?
A. Select Assume Referential Integrity.
B. Change the Cardinality to One to Many (1:*).
C. Change the Cross filter direction to Both.
D. Change the Cardinality to One to one (1:1).
- You Plan To Cre 1 (41.38 KiB) Viewed 73 times
- You Plan To Cre 2 (116 Bytes) Viewed 73 times
B. Change the Cardinality to One to Many (1:*).
C. Change the Cross filter direction to Both.
D. Change the Cardinality to One to one (1:1).