Best data source for reporting using RLS

Anonymous · ‎10-05-2023

Greetings dear members ,

We would like to create reports, but using RLS (Row-level security) so that specific people can only see the data that applies to them. This data would be always updated, we would like to submit new data daily. We tried to create reports from Streaming dataset, but as it turned out afterwards, RLS is not enabled in these reports. Later on, this was solved using e.g. Excel and AzureTable, but neither seems to be the best solution.

Perhaps you can recommend a solution that works for us? Alternatively, we definitely need an external data source from which to extract the data into a dataset, is there not some direct solution where we can send the data directly (like the streaming dataset was) and apply RLS to it? We are talking about 50-100 thousand lines in the first round.

Thanks to everyone in advance.

Best regards

lbendlin · ‎10-06-2023

Instead of a streaming dataset you can consider using a regular dataset with a Direct Query data source. That gives you real time data-ish (maybe with APR), and you can apply RLS rules.