At least as an option, allow fields to be ordered the same as the source query rather than alphabetical. This way they can be put in a logical and consistent order. Obviously, a workaround is to...
This isnt right had to code something to fix a problem with pbi in excel but.... I tried to find a way to fix my ordering columns but fail. so i made a workaround to fix it. Im posting here to help others while the Microsoft dont fix this problem. 'Create in 11/05/2021 'Create by Jonathan Giulian Conzatti 'Input "Column1", "Column2", "Column3", "ColumnN" 'You can get the columns name selecting this in power query and deleting other columns for example 'Output {"Column1", "1 Column1"},{"Column2", "2 Column2"},{"Column3", "3 Column3"},{"ColumnN", "4 ColumnN"} 'Than you can edit your rename column with this set os renames Function NumberColunmsPBI(base As String) As String Dim newSet As String Dim i As Long newSet = "" i = 1 basesplited = Split(base, ",") For Each oldSet In basesplited newSet = newSet & IIf(newSet = "", "", ", ") & "{" & oldSet & "," & Chr(34) & i & " " & Replace(oldSet, Chr(34), "") & Chr(34) & "}" i = i + 1 Next oldSet NumberColunmsPBI = newSet End Function Sub test() Cells(2, 1).Value = NumberColunmsPBI(Cells(1, 1).Value) End Sub
