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
Ability to Isolate Fabric Workspaces Across Browser Tabs and Windows - Power Bi Service
When opening a Fabric workspace in a new browser tab, I cant keep different workspaces open across multiple tabs. The workspace context appears to be shared between tabs. For example: Tab 1 = Dev...aashraysood55 minutes agoMicrosoft EmployeeNew105Views9likes2CommentsSupport VNet data gateway connections in Power BI Report Builder (Get data / Power Query)
Power BI Report Builder can't use a VNet data gateway connection. In Get data (Power Query), the Data gateway field shows "none" and can't be changed, so the query goes straight to the source over th...ilia_ryzhkov8 hours agoNew MemberNew18Views2likes0CommentsOption to set custom width for gridlines OR fixed outer padding
When designing reports, using the align and distribute evenly options in the format pane are useful, however when designing report pages with fixed bleeds between visuals I have to follow these steps...IolaWhiteley16 hours agoAdvocate IINew6Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell17 hours agoNew MemberNew23Views2likes1CommentOption to Stop Fabric Planning Billing Session After Plan Item Deletion
Currently, a Fabric Planning session remains active for 30 days once triggered. If a user creates a Plan item only for testing and deletes it the next day, the billing session still continues and c...v-dugumarrir118 hours agoMicrosoft EmployeeNew48Views11likes1Comment