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
Individual L/R column borders for Matrix
Add Power BI feature for applying left and/or right borders to individual matrix columns, with customizable border thickness and color. This would let users visually group related measures, highlight...AaronReasoner3 hours agoNew MemberNew2Views0likes0CommentsSupport Git-Integrated Files in Fabric Workspaces
Overview Allow users to store and manage arbitrary files such as .md, .sql, .py, and .yml directly in a Fabric workspace, with built-in Git integration. Value This would keep documentation, SQL sc...ryomaru08257 hours agoAdvocate INew34Views4likes1CommentConsistent Locale Handling Across Power BI, Fabric, PowerPoint, and Subscriptions
Microsoft Fabric and Power BI should provide consistent locale handling across all user experiences. Today, locales such as German (Switzerland) are correctly respected in Power BI Desktop and the Po...Le_M9 hours agoRegular VisitorNew22Views1like0CommentsIn Data Pipelines, Schedules should not be part of the definition
The request is to ensure Schedules are not included in the definition of a Data Pipeline for purposes of Deployment Pipelines. Today, when we deploy content across environments, the item frequent...schneiw10 hours agoAdvocate IVUnder Review813Views25likes3CommentsPipeline activity Refresh SQL Endpoint (preview) does not accept dynamic content
I am testing out the new Pipeline activity for Refresh SQL Endpoint, currently in preview. Sure, I get it that this is in preview, but it should at least have basic minimum functionality. It do...ToddChitt10 hours agoSuper UserNew592Views8likes6Comments