Forum Discussion
RLS for external users without Power BI account.
- 3 years ago
Hey PelaezLink ,
unfortunately, there is no simple answer.
The only way to access Power BI content without any kind of authentication is the feature called "Publish to web", but this feature does not support Row Level Security. Please be aware that it is absolutely not recommended to create different reports, one report for a customer and publish these reports to the web. Everyone how has the url can access the report.
Basically there are two solutions.- Add users to your AAD
This means users must be in your Azure AD for authentication, and also must have a license, as you ruled out Premium Per Capacity due to costs, users need to have a Pro license, either they can use their own, or you can assign one of your Pro licenses to these Azure Active Directory users. - Create a Power BI embedded solution
This requires that you create a web app "Embed for your customers" and do the user management from inside the app, this kind of solution requires you to buy a so called A-SKU.
Hopefully, this helps to tackle your challenge.
Regards,
Tom
- Add users to your AAD
Hey PelaezLink ,
unfortunately, there is no simple answer.
The only way to access Power BI content without any kind of authentication is the feature called "Publish to web", but this feature does not support Row Level Security. Please be aware that it is absolutely not recommended to create different reports, one report for a customer and publish these reports to the web. Everyone how has the url can access the report.
Basically there are two solutions.
- Add users to your AAD
This means users must be in your Azure AD for authentication, and also must have a license, as you ruled out Premium Per Capacity due to costs, users need to have a Pro license, either they can use their own, or you can assign one of your Pro licenses to these Azure Active Directory users. - Create a Power BI embedded solution
This requires that you create a web app "Embed for your customers" and do the user management from inside the app, this kind of solution requires you to buy a so called A-SKU.
Hopefully, this helps to tackle your challenge.
Regards,
Tom
Thanks a lot! It was really helpful. Seems like I might be unable to achieve what I am looking for in this way. I might try to try and use the JS Api and maybe create a custom login landing page. Anyways thanks, that was very claryfing and I think it might be useful to others.