DAX query returns both column name and table name but expected to return only column name

[ishwariya12]

he query is generated by the DAX performance analyser for the table used in the dashboards. This query is used in the Power Automate to load the table contents to file. But when the file is generated, each columnas has both Table name + Column name instead of only "Column name".

In the below image, I owuld need only Country, OPS Region, Customer Operator Type and FLO ID

VAR __DS0PrimaryWindowed = 

TOPN(

502,

__DS0Core,

[IsGrandTotalRowTotal],

0,

'Reminder Date'[Reminder Date],

0,

'Geography'[Country],

1,

'Geography'[OPS Region],

1,

'Customer Flags'[Customer Operator Type],

1,

'FT Organization'[FLO ID],

1,

'FT Organization'[FT Organization Name],

1,

'Invoice Type'[Invoice Type],

1,

'Reminder Details'[Invoice Posting Date],

1,

'Reminder Details'[Invoice Number],

1,

'Certification Analyst'[Cert Analyst Full Name],

1,

'Reminder Details'[Invoice Due Date],

1

)

EVALUATE

__DS0PrimaryWindowed

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[OwenAuger]

Hi @ishwariya12 

By default, columns of physical tables will be returned in a DAX query with fully qualified names, i.e. TableName[ColumnName]

You could use SELECTCOLUMNS to rename the columns at the final step of your query, e.g.

EVALUATE
SELECTCOLUMNS (
    __DS0PrimaryWindowed,
    "Reminder Date", 'Reminder Date'[Reminder Date],
    "Country", 'Geography'[Country],
    "OPS Region", 'Geography'[OPS Region] //...
)

The column names will still be surrounded by square brackets. If you want to remove those, I believe you would need to remove them further downstream with Power Automate or otherwise.

Regards