Hi Gulshan. Is there a way via API to check whether a Power BI Report has Row Level Security on not ? I am trying to automate Report Access Provisioning, and if a report has RLS then i want to update the user details in Roles also.
I have one question: Does the end user need workspace access? Then only RLS will work? Or If the end user doesn't have the workspace access then it will work?
Hi, I published and shared report other users but they are getting "report can be viewed as underlying dataset using row-level security".. could you please help me to fix the issue..
How can I pass the value in mysql query dynamically from the report section whatever user selected in filter 1) users select a single date that date should pass on my store procedure which I am calling in power bi while fetching the data from database How can I achieve this please help.
@@LearnAtHomewithGulshan in static mode when i am sending the report for 2 different countries in 2 different mail id it is visible to only to the person whom we have sent first another person report shows blank. please guide what to do in that case. what will be the right approach so that both of them can see their respective report please reply
in static mode when i am sending the report for 2 different countries in 2 different mail id it is visible to only to the person whom we have sent first another person report shows blank. please guide what to do in that case. what will be the right approach so that both of them can see their respective report
@@LearnAtHomewithGulshan while publishing in power BI services it is not visible to the second person with whom I am sharing only visible to the first shared person
RAW - example RAW DATA ( data before cleaning) ROW - example single ROW of a table That's why row label security not raw label security. Hope this help
I am sorry for that. I observed that this video has issue. Could you please check my latest video and please give me feedback. It will help alot thanks in advance.
![Mastering Object Level Security (OLS) in Power BI: Advanced Guide with Tabular Editor [Hindi]](http://i.ytimg.com/vi/H4W78KgWrCw/mqdefault.jpg)
![Mastering Object Level Security (OLS) in Power BI: Advanced Guide with Tabular Editor [Hindi]](/img/tr.png)
![Mastering Incremental Refresh in Power BI: Boost Your Reports Performance! [Hindi]](/img/n.gif)
keep it up. it helps those are not fluent in English.
Good to see this 👍
How should i assign multiple country access to single manager, example- Manager 1 can see data of canada & germany both
In RLS use AND condition for comdition
if i want to create a report and apply dynamic rls for other users then how can i do that??
For dynamic RLS you need a table with user email IDs
Very helpful sir .Appreciate your hard work. Looking forward for more power bi videos.Great work sir .
Sure will create more. Your comment a always motivate me to to upload videos
Hi Gulshan. Is there a way via API to check whether a Power BI Report has Row Level Security on not ?
I am trying to automate Report Access Provisioning, and if a report has RLS then i want to update the user details in Roles also.
Thank you so much brother this video helped me a lot
Thanks 👍
very much helpful - simple + clear - Great work -
Thankyou
Hi, I am able to view while testing out the role but when I am trying to access from the mail ID nothing is getting filtered.
Retest everything again this should work
Hello sir nice information I have one doubt so we have to create separate usertable for dynamic row level security
Yes
Ap bahut acha video bana rahe hai ..
Thank you 😊
Very well presented .Thanks a lot for your effort 😊😊
Thankyou ☺️
Great effort sir, very well explained... Keep uploading such videos
Thankyou for watching.
I have one question: Does the end user need workspace access? Then only RLS will work?
Or
If the end user doesn't have the workspace access then it will work?
User need power bi report access only
Please suggest how to implement this RLS using Ad groups dynamically
Hi, I published and shared report other users but they are getting "report can be viewed as underlying dataset using row-level security".. could you please help me to fix the issue..
great content, waiting for more ..
Thankyou
It's very helpful for me sir 💥
Thankyou
Well done it's a good understanding of RLS
Thankyou Santosh 😊
Bhai superb explanation....very nice...
Thankyou ☺️
in dynamic , u use only one email id gulshan , but i want to view all users ,then how it can be done
you need to create user table in it
Does this help with Page level security even for sensitive data being not overlooked upon,
Or if possible can you build that and showcase
Will make a video on it
full course video kaha milegi ?
Check playlists
How I can free data set for practice?
You can download from kaggle
Hi sir , What if a user can belongs to one or more countries then how can we implement it
Just create another RLS for this person
How can I pass the value in mysql query dynamically from the report section whatever user selected in filter
1) users select a single date that date should pass on my store procedure which I am calling in power bi while fetching the data from database
How can I achieve this please help.
Ok will make a video on it
Nice video perfect 👍
Thankyou 😀
When I create a role through RLS and then view it as the role I created, certain visuals do not change. Do you know why this might be the case?
Explain more this context.
hey bro, plz make a video on, query folding what is the use of it...
Check below video
th-cam.com/video/-K8_tARqF0w/w-d-xo.html
helpful..Thanks
Thankyou 😊
Good job 🎉
Thanks 🙏
Very nice explanation
Thank you
@@LearnAtHomewithGulshan in static mode when i am sending the report for 2 different countries in 2 different mail id it is visible to only to the person whom we have sent first another person report shows blank. please guide what to do in that case. what will be the right approach so that both of them can see their respective report
please reply
in static mode when i am sending the report for 2 different countries in 2 different mail id it is visible to only to the person whom we have sent first another person report shows blank. please guide what to do in that case. what will be the right approach so that both of them can see their respective report
Check both roles filter the data currently in power BI desktop or not
@@LearnAtHomewithGulshan yes it is done
@@LearnAtHomewithGulshan while publishing in power BI services it is not visible to the second person with whom I am sharing only visible to the first shared person
Awesome sir
*Thank you*
Brother thanks for making it in Hindi
It's my pleasure
Very helpful
Abhi toh new update version aa gaya hai RLS mein
Woh wala discuss kareiye na
You can enable that feature from preview option. It is just change in User interface. core concept is the same. see this just a filter based on users.
nice explanation bro
Thankyou
beautiful
Thanks 🙏
Please make a video on cloud sql connect with power bi with security.
Sure
You are being requested that sir please make videos data follow and Workspace
As soon as possible
Bro thanks for making these in hindi
Thanks 👍😊
Could you please share data file for practice...your new subscriber ❤
Row⛔ RAW⤴
RAW - example RAW DATA ( data before cleaning)
ROW - example single ROW of a table
That's why row label security not raw label security.
Hope this help
🤩
Intaa acha mic lgaane and setup krne k baad bhi background audio itna bekaar
I am sorry for that. I observed that this video has issue. Could you please check my latest video and please give me feedback. It will help alot thanks in advance.
Its better atleast subtitles in English
Sure will do
use English only ,I dont know hindi
Then you need to check Analtyics with Nags
I recommended SQLBI channal
Very helpful
Glad you think so!