Forum Discussion
OData passing Data from Embed
- 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.
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.