Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Can we create RLS from my sql server instead of in power BI?

Hi Folks,   I am new to this concept in power BI. Can we create RLS from my sql server instead of in power BI?  If, possible how are we going to map bases on user login's from power BI service? e....
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ToddChitt ,

     

    Sure, I will explore on App settings in power BI service.

    Thanks for you valuable input on this.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
ToddChitt
Icon for Super User rankSuper User
3 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi ToddChitt ,

     

    Sure, I will explore on App settings in power BI service.

    Thanks for you valuable input on this.