Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Power BI Nation,
I have created a SSAS Tabular cube (SQL Server '16) and am building a .pbix file via a live connection. Everything works fine except for the security once I publish file to my app workspace on the PBI service. I have an enterprise gateway set up and the end users of the report have been added to security on the SSAS cube.
So what's the problem? The end users cannot view the content of the app unless if map their user names to that datasource in the gateway admin portal. So basically, every end user I want to distribute this report to, I have to not only add them to security on the SSAS cube, but I also have to map their username in the service? This seems like a huge hassle and an administrative nightmare. What am I doing wrong? Or is this how the process is designed? I would imagine the intent from Microsoft is to only have to add users to security in the underlying SSAS cube and not have to map their user names?
Hi @TheOckieMofo,
>>The end users cannot view the content of the app unless if map their user names to that datasource in the gateway admin portal.
If these users mean external users, you can take a look at following link about add external user as guest to apply RLS effect:
Distribute Power BI content to external guest users with Azure AD B2B
Regards,
Xiaoxin Sheng
No, these are users within my company on my domain. However, this issue is that Power BI passes an email address to SSAS; however, SSAS tabular only lets you set up security by inputing the users User Principal Name (I hope that's the correct terminology). The UPN in our company looks like Domain\username. It does not look like an email address at all. So that's the problem, SSAS doesn't know what to do with the email address it gets from Power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.