Export Underlying Data is not exporting all columns

cheid_4838  Possbile reasons
: Column Is Hidden in the Data Model

• If PO Amount is marked as hidden in the model (even if used in visuals), it won’t show up in the export.
• Fix: Open Power BI Desktop → Model view → Check if PO Amount is hidden. If so, unhide it.

2. Column Is a Measure, Not a Raw Field

• If PO Amount is a DAX measure rather than a column, it won’t appear in the “underlying data” export—only in “summarized data.”
• Fix: Use “Export summarized data” instead, or create a calculated column if appropriate.

3. Data Type Limitations

• Power BI sometimes excludes non-text columns from underlying data exports unless they’re directly used in the visual.
• Fix: Try converting PO Amount to text (if feasible) or ensure it’s explicitly referenced in the visual.

4. Many-to-Many Relationship Complexity

• Many-to-many relationships can cause ambiguous filter contexts, which may lead Power BI to exclude certain fields during export.
• Fix: Try simplifying the relationship or use DAX to clarify the context (e.g., TREATAS, USERELATIONSHIP).

5. Field Not Directly Used in the Visual

• Only fields used in the visual or directly related to it are included in the export.
• Fix: Add PO Amount to the matrix—even if hidden visually—to force inclusion.