Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
Is it possible to retrive the numbers of rows accessable to a specific user in a power bi repport using the power bi api?
Thanks,
Sofia
Solved! Go to Solution.
Hi. Can you try explaining more the scenario and question? from what I can read there it sounds like you have a power bi report with RLS and you want to know the number of rows of a table a user can see using the power bi rest api. That's a no. The only way to check the rows of tables from a user standpoint at an RLS semantic model is if you are de developer and have the power bi desktop to "View as Role". That feature should let you check how specific user can see to check it.
I hope that helps,
Happy to help!
Hi. Can you try explaining more the scenario and question? from what I can read there it sounds like you have a power bi report with RLS and you want to know the number of rows of a table a user can see using the power bi rest api. That's a no. The only way to check the rows of tables from a user standpoint at an RLS semantic model is if you are de developer and have the power bi desktop to "View as Role". That feature should let you check how specific user can see to check it.
I hope that helps,
Happy to help!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
17 | |
16 | |
8 |
User | Count |
---|---|
49 | |
40 | |
32 | |
17 | |
15 |