Tabular
Tabular copied to clipboard
Create Identify issues with SortByColumn columns
this script identifies sortByColumn columns that have more than one value for the column they sort.
Hello Michael, I made this this script and I think it should be in this Repo.
This is a real problem , the validation of the sort columns vs the sorting ones are made by the client tools ( PBI Desktop, SSDT, etc) and if then in the process the sort columns stop having unique value for the sorting ones, there is no warning, but strange behaviors ( for example the processes from Sql Server Agent of a Tabular OnPremise fails or simply when dragging the sorted column to a table in Power BI Desktop appears multiplied in N rows, as many different SortByCoumn values has).
I think this is great, Ricardo. I just updated the code slightly so that it outputs a list of all columns with invalid sort by columns.
do. I just updated the code slightly so that it outputs a list of all columns with invalid sor
Great Michael, thank you very much!!!