You export a Microsoft Excel workbook from Dynamics 365. The workbook contains 10,000 rows of data. You email the workbook and a description of the data to another user. The user reports that they can only see 500 rows of data. You need to determine why the user cannot view all the data .
Why is the user unable view all available data?
A . You selected the This Page Only option and exported a static worksheet.
B . You exported a Pivot Table worksheet. The user does not have the appropriate security role in Dynamics 365 to see all records.
C . You ran a report in Dynamics 365 Customer Engagement and then saved the report as an Excel file.
D . You exported a dynamic worksheet. The user does not have the appropriate permissions in Excel to see all records.
Answer: B
Explanation: https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/export-excel-pivottable
When you export to a dynamic worksheet or _PivotTable_, a link is maintained between the Excel worksheet and Dynamics 365 (online). Every time a dynamic worksheet or PivotTable is refreshed, you’ll be authenticated with Dynamics 365 (online) using your credentials. You’ll be able to see the data that you have permissions to view.
Latest MB-200 Dumps Valid Version with 161 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund