Abubaker Omer’s Post

Microsoft Entra Security Group, FKA AAD-SG, is supported only with Power BI Row-Level Security (RLS), which limits data access for users with Viewer permissions at workspace level. Unfortunately, AD groups are not supported and users with access to a workspace can still access the semantic models within that workspace. #AzureCloud #Power-BI #analytic #reporting #PBI #PowerBI #ServiceFabric # https://lnkd.in/gyVCSt42

Power BI Row level security Option How its work Row-level security (RLS) in Power BI is a powerful feature that allows you to control data access at the row level based on user roles start by creating a Power BI data model that connects to your data sources users interact with the report, RLS dynamically filters the data based on their role #techtip24

Security groups, distribution groups, M365 groups, huh wut? How do I know which one I need for granting access to #PowerBI objects? Fortunately, Gilbert Quevauvilliers has us covered. And thanks to Gabi Münster for pointing out this gem! Go ahead and bookmark this oldie-but-goodie because you'll definitely want to refer back to it. https://lnkd.in/eV8sNAY2

Microsoft has Enhanced Power BI's Row-Level Security Editor! Power BI’s latest update makes securing your data easier than ever! The newly enhanced row-level security editor is now enabled by default, offering a more intuitive interface that lets you define security roles and filters without writing any DAX code. This streamlined approach not only simplifies the process but ensures that your data remains secure with minimal effort. Ideal for ensuring that only the right eyes see sensitive information, this update enhances both usability and security in your Power BI environment. Learn more about the update here... https://lnkd.in/eBFqbqMB #PowerBI #PowerBINews #PowerBIUpdate #PowerBIDevelopment #PowerBIConsulting

How can one read the active security roles in a Tabular model for Power BI or Analysis Services? This can be achieved by using a DAX measure! This way, you can use measures and calculation groups to customize a report based dynamically on security roles active for the current user. Someone in the comment said “Very elegant! I wish I had come up with the idea first”. Is our solution elegant enough? 😉 See it for yourself in the extended version: https://lnkd.in/dqG55uqw

How to read the active security roles in Power BI with DAX by Marco Russo

SETTING UP ROLE LEVEL SECURITY What is role level security: It is the application of security measures based on roles. By defining rules and the roles they apply to, you can manage and restrict access the user has to a dataset. How to set up RLS: Two steps apply which is done first on Power BI desktop and the next on Power BI service.  Define the roles in Power BI desktop Go to the Modelling tab Click on Manage roles Click on the plus icon to create a new role Select the specific table where the attribute is present Use the filter or write the DAX to define the role. The syntax is [column name]= “specified information that should be seen by the role” Add Users to the role on Power BI service Publish the report to Power BI Service Go to your dataset and select "Security." Add the suited users to the roles created #talksaboutanalytics #Dataanalyst

Excel is now 40!!!! Yes, that's correct! Microsoft Excel celebrated its 40th birthday on September 30, 2023. It's incredible to think how far this powerful tool has come since its initial release in 1985. Thank you for being with me😀🥰 Developed an Excel vulnerability dashboard using VBA macro to efficiently analyze server data and identify high-risk systems. Leveraged VBA macro to create a robust Excel dashboard that automates the process of collecting, analyzing, and visualizing server vulnerability data. This dashboard tool effectively highlights high-risk servers, enabling proactive security measures and informed decision-making. Still working on it.... #Excel #vbamacro #vulnerabilitymanagement #vmdashboard

Microsoft Power BI is a powerful tool, but organizations must govern it correctly to get the most out of it. This is where our governance services can help. We assist enterprises in Power BI implementation by providing a formal framework to implement the tool in their organizations. With proper governance, enterprises can improve data security, usability, and the consistency as well as the availability of their services. Learn more here: https://bit.ly/3Bgzgnj #ThinkAI #Microsoft #BI #power BI

Did You Know?💡 4th Question is here: Row-Level Security (RLS) in Power BI is a powerful feature that controls access to data by restricting rows based on roles and an important concept for PL-300. Which of these is NOT a required step to configure RLS? a) Define roles in Power BI Desktop b) Apply filtering logic to tables c) Add users or groups to roles in Power BI Service d) Publish app to the entire organization Comment your answer below and let’s see how many of you get it right! ➡️ Join our community group to get a detailed explanation and resources. https://lnkd.in/gET774u9 ➡️ Bonus: Share how you’ve used RLS in your Power BI projects! #PowerBI #PL300 #DataAnalyst