1 semantic model for 2 reports
Hello, We created a semantic model on Power BI Server that is used across multiple reports. The problem is that we have different RLS to manage per report. For the same user, for the report 1, he has a geographic RLS, for example, and for report 2, he has a domain or company structure RLS. Is it possible to manage different RLSs per report for the same user on a single semantic model? I've tried various methods without success. If anyone has a solution other than multiplying the semantic models, Thank you for your help.
Paginated report embedded for your customer, RLS and CUSTOMDATA()
Hello, I'm using Power BI Premium and additional web application with its own authentication. I have published Power BI report and I am using service principal to communicate Power BI service wit web application. I am passing a parameter from web app to PBI service to know, who is logged in and I am reading that information using CUSTOMDATA() for RLS purposes. It works perfectly well. However, I have published Paginated Report with very same set up and it turned out CUSTOMDATA() retreives null, USERPRINCIPALNAME() and USERNAME() both retreive my login as a report publisher for each logged in user and built in (native) Report Builder function UserID retreives the same string for each logged user as well (it may be my GUID). Question: How to retreive in Paginated Report who is logged in to web app? How to get the same information like CUSTOMDATA() in Power BI but in Report Builder? Thanks
RLS-> Dynamic RLS on hierachy for different colum of a dim table
Hi All, I am hoping find help to my current issue. I have got to implement a Dynamic RLS for hierachy over multiple columns of a dimension table. The requirement consist of implementing an hierachy restriction as follow Besides, an employee/manager can have access to a top level of the hierachy and have his staff accessing only few part of a level (including the belonging part of the below level). => hope this illustraction is clear enough. However, I am having to deal with the blisted below tables: RLS user_Group Table Bridge Table Dimestion table Thank you for your help
Make PowerBI dashboard show only data relative to user
We have a SQL Server Database with real business data and we would like to give insight to our (external) customers using Power BI. In our Web application we are using Power BI embedded with custom authentication. n Power BI we have successfully used UserName() and UserPrincipalName() DAX functions to retrieve user data. On our database, we have a somewhat complex authorization system. We have already functions that return only the right data for the user we pass as argument. We would prefer to use these if possible. It is much preferred that we don't import all the data to Power BI. (Huge amount of data and security concerns) Has anyone done that? Could you suggest how it can be done?
RLS in on premise SSAS tabular live connection with PowerBI Report Server on premise
hi all, I cannot find any documentation nor solutions in the community on the following (but maybe I'm not searching well enough). I have an on premise SSAS Tabular cube with RLS using the folowing DAX =AUT_Kostenplaats[VerantwoordelijkeMedewerkers]=USERNAME() This AUT_Kostenplaats table has a bi-directional relationship to a DIM-table with a single relationship to the fact table. We use Power BI Report Server on premise storing the reports on the server and letting our end users use these reports using the web browser. So no PowerBI Service. I think we've done everything right, but it doesn't work. All I have found so far on RLS combined with the Tabular is on PowerBI Service, and all I have found on RLS with PowerBI Desktop is without the tabular... Hope someone can help! We're really struggling here... Thanks in advance!
