PowerBI Dataset Query in Excel (Column rename)

nytram6 — Thu, 11 Jan 2024 10:30:27 GMT

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.

Re: PowerBI Dataset Query in Excel (Column rename)

amustafa — Thu, 11 Jan 2024 20:24:43 GMT

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]

topic Re: PowerBI Dataset Query in Excel (Column rename) in DAX Commands and Tips

PowerBI Dataset Query in Excel (Column rename)

Re: PowerBI Dataset Query in Excel (Column rename)