Forum Discussion
Can we create RLS from my sql server instead of in power BI?
Hi ToddChitt ,
Sure, I will explore on App settings in power BI service.
Thanks for you valuable input on this.
Hi ToddChitt
Thanks for your input to understany my requiremnt.
Concern 1: I have a SP having seven input parameters I should execute all 7 input param using dynamically this seven parameter has having type conversion.
e.g location field has a input parameter one of the SP (To get the location name in SP the logic is decalred param in SP div datatype int to map the location from a table decalred data type is varchar) same like goes with other input parameter. Is it right apprach to call SP with all those input parameter or View is good approach in this scenario. please advise
concern 2: can we connect SP using Direct connection? I have red few docs no where telling it can be possiable.
Concern 3: can we do incremental refresh using SP?
Super UserForgetting about Incremental Refresh and Direct Query, I want to understand your statement here:
I don't want to implement any RLS concept from Power BI desktop using username or userprinciplename I need to implement at DB end
WHY? Is this a personal preference?
It's like saying "I want to start my car using my left hand and work the gas and brake pedals with my left foot." WHY? Is that your personal preference? Cars (at least in the US) are designed to be started with the RIGHT hand, and operated with the RIGHT foot.) If your answer is because you have no right hand and no right foot, then OK, let's see what we can do.
But if it is simply a matter of because you WANT to do it that way, I suggest you think about doing it in a way that is EASY. You can still do a stored procedure (IMPORT method) and implement RLS in Power BI on top of that data.
By the way, Increment Refresh is for IMPORT, won't work with Direct Query.
Hi ToddChitt
Thanks, My end user want to do there own visuals once report published from power bi desktop. As per Power BI documents Other then viewer role we will not able to implement RLS in power BI service because of this concern I have asking Is there any way can implemt RLS from database using Store procedure itself? If, we can implement at DB side? what is the procedure to restruct underlining data based of user level access? Sorry I am telling same thing again and again to make you to understand my requirement.
- ToddChitt
OK. Now we are getting to the root of the issue. Your requirements are that A) there be Row Level Security on the data so users can only see THEIR data, and B) Create their own visuals.
Please investigate the options for Publishing the APP. On the "Audience" tab, there are check-boxes on the right, in particular, one for "Allow people to build content with the datasets in this app audience."
Users building their own visuals when you enable this setting should still be bound by Row Level Security.
Hi ToddChitt ,
Sure, I will explore on App settings in power BI service.
Thanks for you valuable input on this.