Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
BobbyB_NYC
New Member

Excel: Get Data from Power BI and RLS

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,

 

 

1 ACCEPTED SOLUTION

on the visual click the ellipsis (...) then export then Excel with live connection.

View solution in original post

3 REPLIES 3
BobbyB_NYC
New Member

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.

lbendlin
Super User
Super User

Only if you use "Analyze in Excel"  or "live connection".  If you exported the data then the RLS stops.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.