You have an Excel workbook that contains a table named Sales. You add Sales to the Power Pivot model. You need to set a column named TransactionID as the row identifier for the Sales table. What…

The correct answer is B. From Power Pivot, modify the Table Behavior settings. https://support.office.com/en-us/article/set-table-behavior-properties-for-power-view-reports- c0e8c95e-5bb0-4bd8-a86c-6013301700ca

Model data by using Microsoft Excel

Question

You have an Excel workbook that contains a table named Sales. You add Sales to the Power Pivot model. You need to set a column named TransactionID as the row identifier for the Sales table. What should you do?

Options

AFrom Query Editor, modify the Data Type
BFrom Power Pivot, modify the Table Behavior settings
CFrom Query Editor, add an index column
DFrom Power Pivot, modify the Default Field Set

How the community answered

(44 responses)

A
2% (1)
B
80% (35)
C
7% (3)
D
11% (5)

Explanation

https://support.office.com/en-us/article/set-table-behavior-properties-for-power-view-reports- c0e8c95e-5bb0-4bd8-a86c-6013301700ca

Topics

#Power Pivot#Table Behavior#row identifier#data model

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice