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.
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).
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!