Microsoft
70-778 · Question #95
You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data. In Power BI Desktop, you have the following query for the cube. The query retrieves 25,499 records. When…
The correct answer is C. Delete the Remove Duplicates step. See the full explanation below for the reasoning.
Question
You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data. In Power BI Desktop, you have the following query for the cube. The query retrieves 25,499 records. When you check the data warehouse that is the source of the cube, you discover that there are 26,423 records. You need to ensure that the query retrieves all 26,423 records. What should you do?
Exhibit
Options
- AFrom Query Editor, refresh all the data.
- BChange the query to use Live connection mode.
- CDelete the Remove Duplicates step.
- DAdd an Unpivot Columns step.
How the community answered
(58 responses)- A9% (5)
- B5% (3)
- C83% (48)
- D3% (2)
Community Discussion
No community discussion yet for this question.