The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!