I'd like to pick the community's brain on solutions for RLS when a report is embedded.
Currently, we use RLS on Power BI using an import connection to an analysis services cube. Our web app passes the identifier to the report & users only see what they should. The issue is that import is a difficult model to maintain when you're working with a lot of data. I'd like to move toward a live conneciton, though I know it is not supported.
Would it be possible to setup RLS on the Analysis Services side, create a report using a live connection, publish & embed this to use RLS?
Would it be possible to use parameters in any way to mimic RLS using a live connection?
Thank you in advance!
