Power BI Fundamentals and Microsoft Ecosystem Questions
Fundamentals of Power BI usage, including Power BI Desktop and Power BI Service, data modeling with DAX, report and dashboard design, data connectivity within the Microsoft ecosystem (Excel, SQL Server, Azure Synapse/Azure SQL Database, Azure Data Lake), and governance, security, deployment patterns, and best practices for BI solutions in Microsoft-centric environments
MediumTechnical
0 practiced
Provide a Power Query (M) approach to combine CSV files from a folder in Power BI Desktop, add a column with the source file name, promote headers, and remove any extra header rows that appear in the data. Include how to make the query parameterizable so the same logic works in different environments (dev/test/prod).
HardTechnical
0 practiced
You inherit a chaotic Power BI environment with hundreds of PBIX files, inconsistent naming, many unused datasets, and widespread performance problems. Propose a migration and governance plan: immediate quick wins (inventory, cleanup, certifying high-value datasets), mid-term steps (workspace reorganization, capacity planning, naming conventions, access control), and long-term practices (CI/CD for artifacts, monitoring, training). Include stakeholder engagement and KPIs to measure success.
MediumTechnical
0 practiced
A dataset scheduled refresh fails in Power BI Service with an 'invalid credentials' error for a SQL data source. Walk through a systematic troubleshooting process: check dataset credentials, gateway mapping, gateway health, service account permissions on SQL Server, and logs. Describe possible root causes and corrective steps.
MediumTechnical
0 practiced
Design DAX measures for Month-over-Month (MoM) percentage change and Year-over-Year (YoY) percentage change in SalesAmount. Assume 'dim_date' is a continuous date table and explain sample DAX for both measures including handling divide-by-zero and missing months.
EasyTechnical
0 practiced
In Power BI Desktop, walk me through connecting to an Excel workbook that contains multiple sheets. Describe how you would use Power Query to: combine the sheets into a single clean table, promote headers correctly, remove null or header rows, change data types reliably, and add a column that records the source sheet/file name. Finally, explain how you'd publish the dataset to Power BI Service and set a basic scheduled refresh.
Unlock Full Question Bank
Get access to hundreds of Power BI Fundamentals and Microsoft Ecosystem interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.