I am querying PowerBI datasets via powerautomate then converting and saving the queries as CSVs. The issue I'm running into is that the Column Names in the output have brackets[] around them despite renaming the column names in the query. How can I remove the brackets?
Sample Query:
// DAX Query
DEFINE
VAR __DS0FilterTable =
TREATAS({"Filter Name"}, ‘Sample Table’[Name])
VAR __DS0Core =
CALCULATETABLE(
SUMMARIZE(
‘Sample Table (2)’[Street1],
‘Sample Table (2)’[Street2],
‘Sample Table (2)’[City],
‘Sample Table (2)’[State/Province],
‘Sample Table (2)’[ZIP/Postal Code],
‘Sample Table (2)’[Contact Name],
‘Sample Table (2)’[Contact Phone],
‘Sample Table (2)’[Contact Email],
‘Sample Table (2)’[Alternate Contact Name],
‘Sample Table (2)’[Alternate Phone],
‘Sample Table (2)’[Alternate Email],
),
KEEPFILTERS(__DS0FilterTable)
)
EVALUATE
SELECTCOLUMNS(
__DS0Core,
"Street1",‘Sample Table (2)’[Street1],
"Street2",‘Sample Table (2)’[Street2],
"City",‘Sample Table (2)’[City],
"State/Province",‘Sample Table (2)’[State/Province],
"ZIP/Postal Code",‘Sample Table (2)’[ZIP/Postal Code],
"Contact Name",‘Sample Table (2)’[Contact Name],
‘Sample Table (2)’[Contact Phone],
‘Sample Table (2)’[Contact Email],
‘Sample Table (2)’[Alternate Contact Name],
‘Sample Table (2)’[Alternate Phone],
‘Sample Table (2)’[Alternate Email],
)
ORDER BY
‘Sample Table (2)’[Street1],
‘Sample Table (2)’[Street2],
‘Sample Table (2)’[City],
‘Sample Table (2)’[State/Province],
‘Sample Table (2)’[ZIP/Postal Code],
‘Sample Table (2)’[Contact Name],
‘Sample Table (2)’[Contact Phone],
‘Sample Table (2)’[Contact Email],
‘Sample Table (2)’[Alternate Contact Name],
‘Sample Table (2)’[Alternate Phone],
‘Sample Table (2)’[Alternate Email]
