Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Best data source for reporting using RLS

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

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.