Power BI reports need to be authored in such a way that it they will successfully filter of data using row level security.
Several changes may need to be made to a report for it to work properly. This includes:
A brief walkthrough of this process is described next.
When a report has already been published to Power BI, it can be downloaded using the following steps:
Enter a DAX expression that compares a column value to the DAX function USERNAME(). The USERNAME() function returns the parameter that is supplied by Connect 365 to Power Bi.
In this example, the "contactid" column name contains the uniquely identifying information and it will be compared with the dynamically supplied username value configured within and supplied by Connect 365