Analyze in Excel (and Power BI Publisher) work without issue on datasets without RLS, however when attempting to use with RLS restricted datasets, user receives error "The following system error occurred:" (with no actual error listed). I am the publisher of the dataset, and the Analyze in Excel works for me, however the above mentioned error is received by the user I have shared the dataset with.
3 Comments
- tarostok
Power BI Team
Hi, Analyze in XL should work with RLS. Did you grant the users with a "role" for this dataset? You can contact me and I'll be glad to have a look. Tal - chass
Impactful Individual
Dev Team taking offline with customer - fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Allow Excluding Specific Tables or Columns from Automatic Relationship Detection
Power BI automatically detects and creates relationships between tables when data is loaded. While this is useful, there are scenarios where certain tables or columns are intentionally designed to re...MohamedFowzan14 hours agoSuper UserNew6Views0likes0CommentsHave a DIRECT way to reach the *Transform Data Button* from any menu.
Hi. Currently (2026), in PowerBI you have to go click the HOME menu, than click the Transform Data button, each time you want to reach the Query editor menu. Please either create a dedicated button /...MOFabric5 hours agoRegular VisitorNew6Views0likes0CommentsShow clickable links to dependent objects, aka a usable lineage
I have say 12 reports connected to a semantic model which I have just changed so I need to check if anything has broken. This use to be easy, just click the semantic model to see dependents but this ...skiwii7 hours agoAdvocate INew6Views0likes0CommentsexecuteDaxQueries-like API call with effectiveUserName on SSO-enabled model with Service Principal
Please provide a way for a service principal to execute DAX - with an effective user name - against an SSO-enabled directlake semantic model and get per-user results that respect lakehouse OneLake Se...sean_cochran9 hours agoResolver INew4Views0likes0Comments