PowerBI Dataset Query in Excel (Column rename)

[nytram6]

Hi,

Hoping somebody can help assist with the renaming of column headers when querying a PowerBI dataset in Excel. 

I can live query my required PowerBI dataset in Excel but the column headers are rendered as per the absolute column name (Table[ColumnName]).

My live query looks like this:

DEFINE
	VAR __DS0Core = 
		SUMMARIZE(
			'Append1',
			[Description],
			[Variant Code],
			[Main Supplier],
			[Supplier]
		)

	VAR __DS0PrimaryWindowed = 
		TOPN(
			501,
			__DS0Core,
			[Variant Code],
			0,
			[Description],
			1,
			[Main Supplier],
			1,
			[Supplier],
			1
		)

EVALUATE
	__DS0PrimaryWindowed

ORDER BY
	[Variant Code] DESC,
	[Description],
	[Main Supplier],
	[Supplier]

Then excel returns column header names:

Is there a way to rename this column headers, in the DAX query, to "Description", "Variant Code", "Main Supplier" and "Supplier".

Thanks in advance. 

[amustafa]

I believe SELECTEDCOLUMNS function can rename your columns. Give this a try...

DEFINE
VAR __DS0Core =
SUMMARIZE(
'Append1',
[Description],
[Variant Code],
[Main Supplier],
[Supplier]
)

VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0Core,
[Variant Code],
0,
[Description],
1,
[Main Supplier],
1,
[Supplier],
1
)

EVALUATE
SELECTCOLUMNS(
__DS0PrimaryWindowed,
"Description", [Description],
"Variant Code", [Variant Code],
"Main Supplier", [Main Supplier],
"Supplier", [Supplier]
)

ORDER BY
[Variant Code] DESC,
[Description],
[Main Supplier],
[Supplier]