اضغط هنا للانضمام الى قروب فوجي للإختبارات على تيليقرام

اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

السؤال 17 من 50

كل الأسئلة

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?

الخيارات

  • A Create a custom function to read the referenced SharePoint list.
  • B Read the lists separately, and then append the lists.
  • C Expand the referenced column of the query.
  • D Read the lists separately, and then merge the lists.

النقاشات

لا توجد نقاشات منشورة لهذا السؤال حالياً.