Power BI Interview Q & A

??Calculated Column vs Measure:Calculated Column: Computed during data load, stored in the table, and can be used in slicers and filters.Measure: Calculated on the fly during report interactions, not stored in the table.

?? DirectQuery vs Import Mode:DirectQuery: Queries data directly from the source each time the report is used.Import Mode: Imports data into Power BI, providing faster performance but requiring scheduled refreshes.

?? Filter vs Slicer:Filter: Can be applied to visuals, pages, or the entire report, and is not visible to endusers.Slicer: Visual control on the report canvas that allows endusers to filter data.

?? Power BI Desktop vs Power BI Service:Power BI Desktop: Application for creating and designing reports.Power BI Service: Online platform for sharing, publishing, and collaborating on reports.

?? DAX vs M Language:DAX: Used for calculations and data analysis, working with data already loaded into Power BI.M Language: Used in Power Query for data transformation before loading into Power BI.

?? Table vs Matrix Visual:Table: Displays data in a flat, tabular format.Matrix Visual: Displays data in a pivot table format, allowing rows and columns to be grouped.

?? Drillthrough vs Drilldown:Drillthrough: Navigates to a detailed page within the same report based on a specific data point.Drilldown: Expands a hierarchical data structure within the same visual.

?? Append Queries vs Merge Queries:Append Queries: Combines data from two or more tables into one table.Merge Queries: Joins data from two or more tables based on a common column.

?? Gateway vs Personal Gateway:Gateway: Used for live and scheduled refreshes for multiple users, supporting enterprisewide scenarios.Personal Gateway: Used for individual users to refresh data in Power BI Service from onpremises sources.

?? Calculated Table vs Calculated Column:Calculated Table: A new table created by a DAX formula.Calculated Column: A new column added to an existing table using a DAX formula.Follow more for Supram Bharatee #EXCEL #PowerBI #DataAnalysis #BusinessIntelligence #DataVisualization #DataDriven #Analytics #BusinessIntelligence #LinkedInCommunity