Brackets around Column Names in Dax query via Power Automate

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]