Hi all,
Regarding default filter for Power BI, I found this link : Help secure analytical workspaces and reports by using Power BI Embedded - Finance & Operations | Dynamics 365 | Microsoft Docs
Which actually question come to mind:
1. At this point ->
Create a new role against a column in the data model that contains the Company field. Name the new role CompanyFilter. A COMPANY field must be present in the data model to restrict access by company.
Question: Should the role name the exact word "CompanyFilter" ?
2. At this point ->
In the Table filter DAX expression field, enter [COMPANY]=username().
Question: the [Company] here is the original field or field name at my current data model ? Since in Power BI we can rename the field, so if later after for example I rename my entity name, lets say I have LegalEntities.company then rename it as LegalEntity.comp.. -> should I go to Role again and change the DAX expression accordingly.
3. And how actually the work or to test it, since I tested with my colleague email id which he doesn't have access to my testing environment which also makes no company he can access, but the report still showing data.
Thanks
