Forum Discussion
Can I Only Refresh the Row-Level-Security Table?
Hello everyone. Pretty much what title says. I want to refresh only the RLS table to pick up access changes during the day without refresh the entire Dashbaord/Dataset. Is there any easy way to achecive that? Thank you.
1 Reply
Yes,
If you have premium/premium per user you can refresh a table via the xlma end point (as a starting point connect to it via ssms or tabular editor and get it to generate a script.
Alternatively you can use the Enhanced refresh now available in rest api to do the same: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset
You can build that as a custom connector in power automate and run it on a schedule. (I'm away camping but can send details next week).
