You use Power Query Editor to ingest data into Power BI Desktop from two Microsoft SharePoint Online lists named Customers and Locations. Each list contains more than 25,000 rows. Locations is referenced in Customers to generate qualified values in a drop-down list. You create the following query in Power Query Editor. You experience long load times and discover that Power Query Editor makes calls to the URL of each row in the final dataset. You need to optimize the query. The solution must minimize development effort. What should you do?
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.
