Forum Discussion
After automatic refresh, permissions disappear
Hi JaniceBradley ,
I think you are right. RLS doesn't work with SQL Server on-premises in Power BI Embedded.
Maybe you can try to use live connection mode to connect SSAS instead of SQL Server.
Create a new tabular model project
RLS in Analysis Services tabular model
Manage data source - Analysis Services
Row-level security with Power BI Embedded
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak Thanks. So the issue would be with the custom application, there's nowhere to look in power bi service? I haven't configured the application so I don't know my way around. I believe however that the first step in the application is: bool getCredentialsResult = await GetTokenCredentials();
Could it be a case that RLS has not been setup in the application?
Thanks.
Just looking a bit further. In the article you reference above, it mentions the following:
Token-based Identity limitations
RLS doesn't work with SQL Server on-premises.
My data source is an SQL on-premises server. Does this mean that the token based auth in embededed will not work?
Thanks.
Hi JaniceBradley ,
I think you are right. RLS doesn't work with SQL Server on-premises in Power BI Embedded.
Maybe you can try to use live connection mode to connect SSAS instead of SQL Server.
Create a new tabular model project
RLS in Analysis Services tabular model
Manage data source - Analysis Services
Row-level security with Power BI Embedded
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.