Sébastien De Bosscher on 08 Apr 2021 06:36:56
Featured Tables in Excel’s Data Types gallery doesn't work when I create one (or more) role(s) in power BI desktop for RLS. I leave the Table filter DAX expression blank in power BI desktop, so I should have access to all rows. It just doesn't work in spite of the power BI team mentioning:
RLS is now supported for Featured Tables in Excel’s Data Types gallery:
"We’ve continued to improve the featured tables capability with row-level security support. Now, when you mark a table as featured and then publish to the Power BI service, that table will appear in Excel’s data types gallery even if it has RLS rules applied. Previously, these tables were not shown in Excel. This new enhancement means that users in Excel will only see the rows of data they have access to."
-
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2020-feature-summary/
Yes, I do see the featured table in Excel, but it recognizes none of my selected Excel cells when the power BI report has Roles (RLS). The moment I remove the role in the power BI desktop file and republish everything works as expected.