Can be able to filtered data without using RLS?

[rameshmadhubhas]

In Power BI, have two tables: one for UsersData and one for CountryData.

The Username and Country columns can be identified in the UsersData table and the Country and CityName columns are in the CountryData table. The CountryData and UsersData tables are connected by using Country. Visualize the Country name and city in a table in the Power report view.

Requirement: When a user logs into the power bi service, he wants to see only the data related to the user. I looking for any suggestions to implement this scenario without using RLS.

[v-xiaoyan-msft]

Hi  @rameshmadhubhas ,

One way to filter it is to start with the default URL for the report, add the filter parameters to the URL, and then email them the entire new URL. 

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

URL filters are supported in some embedding scenarios and not in others.

• Embedding a report in a secure portal or website is supported.
• URL filters are supported in Power BI Embedded. See Power BI Embedded advanced URL filtering capabilities for details.
• Query string filtering doesn't work with Publish to web or Export to PDF.
• Embed with report web part in SharePoint Online doesn't support URL filters.
• Teams doesn't allow specifying a URL.

Best regards.
Community Support Team_Caitlyn

[rameshmadhubhas]

Hi @v-xiaoyan-msft 

This solution is not enough to reach my requirement.

Finally, I'm going to Power BI Embedded Analytics (Embed for your customers/ app owns data) solution for the analytics report.

I am looking for some approach to filter the data from the table level (I mean tables that include in Data view and Model view) without using RLS. As an example, I want to create a new table called UserCities, its data needs to be filtered by the user who logs into the power bi service.

I tried the following query, but it gives some errors.

 UserCities = CALCULATETABLE(

DISTINCT(

SELECTCOLUMNS('Countries',

"Country", 'Countries'[Country],

"City", 'Countries'[CityName]

)

), Users[UserName] = USERPRINCIPALNAME()

)