MSBI and Power BI Developer Interview Questions and Answers for Freshers

Transformations in Power Query include filtering, sorting, grouping, pivoting, unpivoting, merging, appending, and more.

• Filtering data based on specific criteria

• Sorting data in ascending or descending order

• Grouping data to perform aggregate functions

• Pivoting data to change the layout of the table

• Unpivoting data to normalize the table structure

• Merging data from multiple sources

• Appending data from multiple tables or queries

SUM is an aggregation function in DAX that adds up all the values in a column, while SUMX is an iterator function that performs a calculation for each row in a table.

• SUM is used to calculate the total of a column, while SUMX is used to iterate over a table and perform calculations row by row.

• SUM ignores any filters applied to the column, while SUMX considers the current row context.

• SUMX is commonly used with iterators like FILTER or RELATED to perform more complex calculation...read more

RLS can be applied to reports by defining role-based security rules in Power BI Desktop or Power BI Service.

• Define roles in Power BI Desktop or Power BI Service

• Assign users to roles

• Create role-based security rules to restrict data access based on user roles

Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.

• Business analytics tool by Microsoft

• Provides interactive visualizations

• Offers business intelligence capabilities