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.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow External OneLake Data Shares to Be Accepted into Multiple Fabric Item Types
Fabric External Data Sharing provides an excellent zero-copy mechanism for sharing OneLake data across tenants. However, the receiving tenant currently has to accept the share into a Lakehouse. I w...Mourak6 hours agoNew MemberNew5Views0likes0CommentsAllow OneLake Shortcut Authentication Mode to Be Changed In Place
OneLake shortcuts support passthrough and delegated authentication, but changing the authentication model currently requires deleting and recreating the shortcut. I would like shortcut authenticatio...Mourak6 hours agoNew MemberNew6Views0likes0CommentsTenant-Wide OneLake Shortcut Lineage and Impact Analysis
This is grounded in a documented limitation: shortcut lineage is currently workspace-scoped, and Microsoft specifically says lineage for shortcuts to warehouses and semantic models isn't currently av...Mourak6 hours agoNew MemberNew6Views0likes1CommentAdd an End-to-End Production Reference Architecture for Microsoft Fabric Real-Time Intelligence
I would like to see a complete end-to-end Microsoft Fabric Real-Time Intelligence reference architecture that demonstrates how the individual RTI capabilities work together in a production-oriented s...Mourak6 hours agoNew MemberNew3Views0likes0CommentsImprove CI/CD consistency for Microsoft Fabric Real-Time Intelligence Eventstreams
Microsoft Fabric Real-Time Intelligence has made strong progress with Git integration and deployment pipelines, but lifecycle management can still be inconsistent across Eventstream sources, destinat...Mourak6 hours agoNew MemberNew2Views0likes0Comments