POWER BI [PI-300]: You have a query that retrieves data from a table that contains more than 8,000 rows of data. In Power Query Editor, you notice that the column statistics for each column shows a count of exactly 1,000. You need to ensure that the column statistics for each column shows the statistics based on all rows that are returned by the query. What should you do?Select only one answer. Add a Table.Buffer applied step to the query. Change the query load type from Import to DirectQuery. Create a Top N row count parameter for the query. From the query window, select Column profiling on the entire dataset.

Question

You have a query that retrieves data from a table that contains more than 8,000 rows of data. In Power Query Editor, you notice that the column statistics for each column shows a count of exactly 1,000. You need to ensure that the column statistics for each column shows the statistics based on all rows that are returned by the query. What should you do?Select only one answer.  Add a Table.Buffer applied step to the query. Change the query load type from Import to DirectQuery. Create a Top N row count parameter for the query. From the query window, select Column profiling on the entire dataset.

da-bi · Accepted Answer

From the query window, select Column profiling on the entire dataset.
This answer is correct.

POWER BI [PI-300]

From the query window, select Column profiling on the entire dataset. This answer is correct.

Author