A Power BI model contains a Sales fact table with 500 million rows in Azure Synapse. The team wants fast interactive reports without importing data. Which connectivity approach provides the best query performance while keeping data in Synapse? Power BIHard Try Now
Which DAX function is used to iterate over a table and return a single scalar value by applying an expression to each row? Power BIHard Try Now
A developer needs to dynamically change the measure displayed in a visual based on a slicer selection (e.g., toggling between Revenue, Profit, and Units). Which Power BI technique achieves this? Power BIHard Try Now
A Power BI developer needs to create a measure that returns the percentage contribution of the selected category to the grand total, remaining correct regardless of which slicers are applied. Which DAX pattern is correct? Power BIHard Try Now
In Power BI Paginated Reports, what is the primary use case compared to standard Power BI reports? Power BIHard Try Now
Which deployment strategy in Power BI Premium allows teams to manage separate Development, Test, and Production environments with a streamlined promotion workflow? Power BIHard Try Now
In Power BI, when would you use Object-Level Security (OLS) instead of Row-Level Security (RLS)? Power BIHard Try Now
A Power BI dataset uses Incremental Refresh. What are the two mandatory Power Query parameters required to configure incremental refresh? Power BIHard Try Now
In Power Query, a developer wants to parameterize a data source connection so the server name can be changed without editing query steps. What is the correct approach? Power BIHard Try Now
Which Power BI Service role allows a user to edit and publish reports in a workspace but prevents them from adding or removing other workspace members? Power BIHard Try Now
A developer notices that a Power BI report runs slowly because a complex DAX measure is evaluated repeatedly for each row in a matrix visual. Which optimization technique should they apply first? Power BIHard Try Now
In Power BI composite models, what does ‘DirectQuery for Power BI datasets and Analysis Services’ enable? Power BIHard Try Now
What is the behavior of RANKX() when there are tied values and the ‘Dense’ ranking order is specified? Power BIHard Try Now