Forum Discussion

Don-Bot's avatar
Don-Bot
Icon for Helper V rankHelper V
1 year ago
Solved

Export To file in group receiving needs effective identity error

I am currently trying to run the export to file in group rest api however I am getting the "needs effective identity" even though I am providing that.  Can someone point to me as to what I am doing w...
  • v-sdhruv's avatar
    1 year ago

    Hi Don-Bot ,

    The  " needs effective Identity" error typically means Power BI was not able to resolve the Effective Identity you're passing. Even though you're providing one, it's likely that one or more parts of it are incorrect or incomplete.
    Here’s some steps you can follow how to fix them:

    1. Check RLS - Make sure  (RLS) is enabled on the dataset

    If the dataset does not have RLS roles defined, Power BI will ignore the Effective Identity, and you'll get this error. Check that:

    • The dataset you're targeting has at least one RLS role (e.g., "Company User")

    • The user you're simulating (Username) is valid for that role

    Go into Power BI Desktop → "Modeling" tab → "Manage Roles" → ensure "Company User" role exists.

     

    2. Use the powerBIReportConfiguration Wrapper

    The identities field should not be top-level. It should go inside the powerBIReportConfiguration object.

    Wrap identities under  powerBIReportConfiguration

    3.Check the response body when the API fails. Even if  response.IsSuccessful is  false , the  response.content might contain a message like : "The effective identity is invalid."
    Log it for easier debugging.

    Hope this helps!
    If the response has addressed your query, please Accept it as a solution ' so other members can easily find it.
    Thank You