16 Add Prefix/Suffix Transform Tab Nov-2015 to a Text column Format Add Prefix or Also available in Add Column tab for creating a derived column with suffix or prefix Previously had to use a custom column and ampersand symbol 17 Append Multiple Have always Tables supported only two tables at a time and had to create multiple queries to support many source tables Can also append multiple copies of an existing table 18 Data” Previously had to “Refresh for individual click Refresh from tables from Field Home Tab and this Option also exists from dialog in Data View with Table selected List (Report and would refresh all Data Views) queries in the model
16 Add Prefix/Suffix to a Text column Transform Tab Format Add Prefix or Also available in Add Column tab for creating a derived column with suffix or prefix Previously had to use a custom column and ampersand symbol Nov-2015 17 Append Multiple Tables Have always supported only two tables at a time and had to create multiple queries to support many source tables Can also append multiple copies of an existing table 18 “Refresh Data” for individual tables from Field List (Report and Data Views) Previously had to click Refresh from Home Tab and this would refresh all queries in the model Option also exists from dialog in Data View with Table selected
pbi-desktop-data-transformation-features.docx