Forum Discussion

PhilSteel's avatar
PhilSteel
New Member
4 years ago
Solved

OData passing Data from Embed

Hi I'm getting started with integrating with Power BI Embedded.   Our Application has an ODATA (Also a Rest Endpoint) endpoint which returns data based on a users permissions both row based and co...
  • v-chenwuz-msft's avatar
    4 years ago

    Hi PhilSteel ,

     

    This does not seem to be able to do that, because getting the data belongs to the model level. For reports, it will only have one dataset, regardless of how many users you have.


    If follow your logic, the dataset will be refreshed every time a user logs in, and if multiple users log in to the report at the same time, it will cause the dataset to be refreshed, resulting in inconsistent data, with the next user's refresh overwriting the previous user's data.

     

    Pwoer bi report accesses the dataset and fetches data according to the defined dax, so you need to refresh all the data that all users may use into the dataset and present different data according to the user's token.
    If rls does not meet your needs, you can try OLS in power bi.

    Analysis Services tabular model object-level security | Microsoft Docs

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.