@Jmenasthank you for your suggestion.
I have modified that query and created it as a brand new append query. This is the result:
let
Source = Table.Combine({PBI_WagesCat_appended, PBIDIm_CostPersonCat_new}),
#"Filtered Rows" = Table.SelectRows(Source, each ([Cont] <> null))
in
#"Filtered Rows"
I have republished the report and hit refresh in PBI Service. After making sure that the same level of privacy is set. Result: another table gave me the same error (built in the same system, with information appended to the intial table). Fixed it in the same way, then another table gave me the error, I fixed this one too.
But at the end I got the error for one of the tables I just fixed. Same error message. This is the query for the table that gave me the error last time:
let
Source = Table.Combine({Salary_appended, #"Costs-Employee-2018_new", #"2018_IndirectCosts", #"Salary&CostPerPerson_Real", GlobalCost_Real_Indirect}),
#"Changed Type1" = Table.TransformColumnTypes(Source,{{"End Date", type date}, {"C-TKI-Tenders", type number}, {"C-TKI-Online", type number}, {"C-TKI-Partnership", type number}, {"C-TKI-International", type number}, {"C-CP", type number}, {"C-RO", type number}, {"C-CPTI", type number}, {"Expense category", Int64.Type}}),
#"Unpivoted Only Selected Columns" = Table.Unpivot(#"Changed Type1", {"C-TKI-Tenders", "C-TKI-Online", "C-TKI-Partnership", "C-TKI-International", "C-CP", "C-RO", "C-CPTI", "C-Integer-Detunata-RENT", "C-TKI-Other"}, "Attribute.1", "Value.1"),
#"Filtered Rows" = Table.SelectRows(#"Unpivoted Only Selected Columns", each true),
#"Changed Type3" = Table.TransformColumnTypes(#"Filtered Rows",{{"Value", type number}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type3",{{"Attribute.1", "Client intern"}, {"Value.1", "Pecentage"}}),
#"Changed Type2" = Table.TransformColumnTypes(#"Renamed Columns",{{"Pecentage", type number}, {"Department ID", Int64.Type}, {"Status ID", Int64.Type}, {"Entity ID", Int64.Type}, {"Start Date", type date}})
in
#"Changed Type2"
Then I republished the report with another name and I got the same error for query No 1 mentioned above, again (you can see it again below)
It has 2 columns: a text column and the ID column (int).
let
Source = Table.Combine({PBI_WagesCat_appended, PBIDIm_CostPersonCat_new}),
#"Filtered Rows" = Table.SelectRows(Source, each ([Cont] <> null))
in
#"Filtered Rows"
I hope that Microsoft will fix this issue as soon as possible.
