176 votesErik commented
Is there any update on this feature request?
I need to only allow access to data through RLS based on regions an admin user can dynamically add/delete/alter in our application. In order to do this I need to be able to create/delete new roles programmatically as our client's admin creates/deletes these regions.
Without this feature there isn't a workable solution that I can see
And thanks for your feedback!
We recently released a new API- https://msdn.microsoft.com/en-us/library/mt814715.aspx
Which helps update connection for AS & SQL, for DQ, live connection or import model.
We will soon release support for more data sources, as well as ability to change parameters inside the connection string, which should handle rest of data sources.Erik commented
I'd like to second this request. I need to stripe out 1 report across 100+ different workspaces which should each read from their own unique Azure Data Lake Store.
If I can't programmatically point the dataset to other data sources, I'd need to manually edit each dataset in each workspace in power BI. That may be technically possible for this report, but I'm also trailblazing for future reports to be added. Extending this process across multiple reports is completely untenable.