Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
n Power Query, even if you add the filter step after creating the initial query connection, query folding typically still occurs if the filter uses supported operations and you haven't broken folding with intermediate steps
Ok this is a bit unclear. We do not know wich filter is applied. While most simple filters should be pushed to the database with query folding - it is not guranteed. BUT the question did not ask about performance - only about the sample. -> therefore I say "Yes"
You want sample data. So you don't import; you transform and go to Advanced editor and: let Source = YourTableName, AddRandomColumn = Table.AddColumn(Source, "Random", each Number.RandomBetween(0, 1000)), SortedTable = Table.Sort(AddRandomColumn, {"Random", Order.Ascending}), SampleData = Table.FirstN(SortedTable, 100) // Retrieves 100 random rows in SampleData