What is RLS? How many types are there?
Answer: RLS stands for Row-Level Security. It is used to control access to data at a row level based on user roles and permissions. There are two types of RLS: Role-Based and User-Based.
What is incremental refresh, and what are the two parameters used in incremental refresh?
Answer: Incremental refresh is a feature in Power BI that allows you to refresh only a portion of your data to improve performance. The two parameters used in incremental refresh are "RangeStart" and "RangeEnd," which define the time period for the refresh.
Difference between SUM and SUMX:
Answer: SUM is an aggregation function used to calculate the total of a column in a table. SUMX is an iterator function that calculates the sum of an expression over a table, considering row context.
How many types of licenses are available?
Answer: There are mainly two types of licenses in Power BI: Power BI Pro and Power BI Premium.
Difference between Pro user & Premium user:
Answer: A Pro user has access to Power BI service with individual licenses, while a Premium user accesses Power BI service through capacity-based licensing, enabling the sharing of reports and dashboards with free users.
What are Gateways, and how many types of gateways are there?
Answer: Gateways are used to connect on-premises data sources to Power BI service. There are two types of gateways: Power BI On-premises data gateway and Power BI Personal gateway.
What is Power BI service?
Answer: Power BI service is a cloud-based platform where you can publish, share, and collaborate on Power BI reports and dashboards.
Difference between calculated column and Measure:
Answer: A calculated column is a column created in a table with a DAX formula that is evaluated row-by-row and stored in the table. A measure is a calculation that works with aggregated data and provides results based on user interactions.
What are the roles in the workspace (Admin, Member, Viewer, and Contributor)? Answer: In a Power BI workspace, there are four roles:
Admin: Full control over the workspace, including managing access and settings.
Member: Can edit and publish content within the workspace.
Viewer: Can view content within the workspace but cannot make changes.
Contributor: Can contribute content to the workspace but has limited administrative rights.
