Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I have a power BI semantic model that is accessed with Excel: Get Data from Power BI. The underlying semantic model has RLS that funcitons in Power BI. Is there a way for the RLS to function in Excel when accessing data this way?
Many thanks,
Solved! Go to Solution.
on the visual click the ellipsis (...) then export then Excel with live connection.
1)To use "anaylze in excel" I am picking that option from the semantic model. Is this correct? Visually, it looks identical to Excel: Get Data from Power which from my testing does NOT seem to maintain RLS. BI. I haven't tested "anaylze in excel" yet to confirm but seems like would have same funcitonality as Excel: Get Data. Maybe I'll be presently surprised?
2) How do i create a "live connection". I have not yet found MS section that clearly explains this.
Thanks for your help.
on the visual click the ellipsis (...) then export then Excel with live connection.
Only if you use "Analyze in Excel" or "live connection". If you exported the data then the RLS stops.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 9 | |
| 9 | |
| 7 |
| User | Count |
|---|---|
| 47 | |
| 40 | |
| 39 | |
| 25 | |
| 25 |