19+ practice questions focused on Demonstrate capabilities of Power BI — one of the most tested topics on the Microsoft Power Platform Fundamentals PL-900 exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Demonstrate capabilities of Power BI PracticeA sales manager wants to create a Power BI report that shows monthly sales trends and allows drilling down from year to quarter to month. Which feature should they use?
Explanation: A hierarchy in Power BI allows users to create a parent-child relationship between fields (e.g., Year → Quarter → Month) that enables automatic drill-down and drill-up actions in visuals. This directly supports the sales manager's requirement to view monthly trends and drill from year to quarter to month without manual configuration.
A company has a Power BI dataset that refreshes daily. Users report that the report shows stale data from two days ago. What is the most likely cause?
Explanation: The most likely cause is that the scheduled refresh has failed for the past two days. Power BI datasets that rely on scheduled refresh must complete successfully to update the data; if the refresh fails, the dataset retains the last successful refresh’s data, which in this case is from two days ago. Users seeing stale data from two days ago directly indicates that the refresh has not succeeded since then.
A marketing team wants to share a Power BI dashboard with external partners who do not have Power BI licenses. What is the recommended approach?
Explanation: Option B is correct because 'Publish to web' creates a public embed code that allows anyone on the internet to view the dashboard without requiring a Power BI license or authentication. This is the only built-in method in Power BI that enables sharing with external users who have no Power BI Pro or Premium Per User (PPU) licenses, as it bypasses the license requirement entirely by making the report publicly accessible.
A data analyst needs to combine data from two Excel tables that have a common column 'ProductID'. Which Power BI tool should they use?
Explanation: Merge Queries is the correct tool because it combines two tables by matching rows based on a common column (ProductID), similar to a SQL JOIN. This allows the analyst to bring in additional columns from one table into the other, which is exactly what is needed when data from two Excel tables must be integrated on a shared key.
A Power BI report uses a calculated column that shows [Sales Amount] * 1.1. Users notice the column shows incorrect values after a data refresh. What is the most likely cause?
Explanation: Option A is correct because if the DAX formula was edited to multiply by 1.2 instead of 1.1, the calculated column would produce values 9.09% higher than expected after the refresh. This directly explains the discrepancy users observe, as calculated columns are recomputed during data refresh based on the current formula definition.
+14 more Demonstrate capabilities of Power BI questions available
Practice all Demonstrate capabilities of Power BI questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Demonstrate capabilities of Power BI. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Demonstrate capabilities of Power BI questions on the PL-900 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Demonstrate capabilities of Power BI is tested as part of the Microsoft Power Platform Fundamentals PL-900 blueprint. Practicing with targeted Demonstrate capabilities of Power BI questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free PL-900 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Demonstrate capabilities of Power BI is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Demonstrate capabilities of Power BI practice session with instant scoring and detailed explanations.
Start Demonstrate capabilities of Power BI Practice →