Power BI Data Analyst

A dataset must combine data from a SQL Server database, an Excel workbook, and a SharePoint list. Where does a Power BI analyst connect to and shape all of these sources?

A compliance rule states report data may never be persisted inside the PBIX/model — every visual interaction must query the source database directly. Which storage mode satisfies this?

Before modeling, an analyst wants to check a column for empty values, errors, and the distribution of distinct values across the full dataset. Which Power Query settings enable this check on more than the default sample?

A query against a data warehouse applies Filter Rows, then Remove Columns, then a custom M function that cannot fold. How should the analyst order the steps for best performance?

Regional sales files with identical columns arrive monthly into one folder. The analyst wants Power BI to automatically combine ALL current and future files in that folder into a single table. Which approach fits?

A source column mixes customer names like 'john SMITH' with inconsistent casing, plus leading spaces. Which Power Query transformations clean it?

During refresh setup, a 500M-row fact table must load only new and changed recent data instead of everything, using RangeStart and RangeEnd parameters. Which feature is being configured?

Multiple teams' datasets need the same cleansed 'Product Catalog' table, prepared once in the cloud with Power Query and reused everywhere. Which Power BI service item should be created?

An analyst inherits a model that is one huge flat table with 150 columns mixing sales amounts, product details, and customer details. What is the recommended remodeling?

When relating the Customer dimension to the Sales fact table in Power BI, which cardinality is expected for a healthy model?