PrepAway - Latest Free Exam Questions & Answers

You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data.

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?

A. From Query Editor, refresh all the data.

B. Change the query to use Live connection mode.

C. Delete the Remove Duplicates step.

D. Add an Unpivot Columns step.


Leave a Reply