Forum Discussion

MFoo's avatar
MFoo
Frequent Visitor
4 years ago

Publishing PBI does not always respect RLS

We're a PowerApps ISV company and we have a solution that's a model-driven app based on PowerApps, it's an evolution from the original offering that was based off D365.    We generate a lot of data...
Data Protection
MFoo's avatar
MFoo
Frequent Visitor
4 years ago

Hey Eason, 

 

Thanks for the reply.  

 

For an ISV, PowerBi's RLS is rubbish.  Any data system will have security measures in place and the expectation to replicate that in a separate reporting system is a complete waste of time, unless of course you're paid by the hour.

 

Direct Query PowerBI reports from SQL Server with credential pass-through WILL and DOES honour the user's security settings IF you publish "correctly", as per my original post.

 

My question is why is there a difference?  And secondly, should there be a difference?  I would think that publishing a report from PowerBI desktop to Powerbi.com via ANY of the mechanisms Microsoft provide should be a consistent experience with consistent end results, surely?

 

Or is that not what I should be expecting?  Happy to be wrong but would love to understand why.