BDO India LLP Data Reporting Analyst Interview Questions and Answers

RLS in Power BI stands for Row-Level Security.

• RLS allows you to restrict access to certain rows of data based on the user's role or permissions.

• It helps in ensuring that users only see the data that they are authorized to view.

• RLS can be implemented by creating roles and defining filters based on user attributes or roles.

• For example, you can use RLS to restrict a sales manager to only see data related to their region.

Use regex to find dates in Python strings.

• Import the re module in Python for regex operations.

• Use the re.findall() function to find all matches of a regex pattern in a string.

• Create a regex pattern to match dates in various formats, such as 'MM/DD/YYYY' or 'YYYY-MM-DD'.

• Example: regex_pattern = r'\d{2}/\d{2}/\d{4}' will match dates in 'MM/DD/YYYY' format.