Page 17

• 3rd sentence of the final paragraph should read:
  • We’re not
    going to do this now, but if you wanted to, you would go to the Applied Steps window and click the X to the
    left of the Renamed Removed Columns step.
• Fixed in Digital Edition: 2023-01
• Fixed in Print Edition: 2nd Printing

Page 19

• List item 3 at the bottom of the page should read:
  • While performing two “like” actions in succession results in the steps being combined (as we saw
    with the Removed Renamed Columns step), similar actions will not be combined into a single step if there is a
    different step between them
• Fixed in Digital Edition: 2023-01
• Fixed in Print Edition: 2nd Printing

Page 72

• In the text we indicate that you can change the path to an imported file via the Home -> Transform Data -> Data Source Settings dialog.  Unfortunately there appears to be a bug in Power BI Desktop that is causing the Change Source button to be greyed out (and unclickable).  Until this bug is fixed, the only way to update a connection is to edit the Source step via the Formula bar or edit the M code directly.
• Fixed in Digital Edition: 2023-01
• Fixed in Print Edition: 2nd Printing

Page 85

• 2nd to last bullet should read as follows:
  • Select the Tran Date column -> Home tab -> Remove Rows -> Remove Errors
• Fixed in Digital Edition: 2023-01
• Fixed in Print Edition: 2nd Printing

Page 147

• The final warning should read:
  • What happens if you fail to anticipate an issue and get a step level error in one of the files when you run the Combine? You will need to debug it, of course! Go back to the FilesList query and insert temporary steps to keep the top x rows or remove top x rows until you discover which file query causes the error. Once you have it as the first file query in the FilesList query, you can then debug it in the Transform Sample File query to see what went wrong.

• Fixed in Digital Edition: 2023-01
• Fixed in Print Edition: 2nd Printing

Page 204

• The set of bullets immediately above the image should read
  • Create a new Query -> From Text/CSV -> Ch13 Examples\Stacked Data.txt
  • If no “Promoted Headers” step is shown in the Applied Steps panel, go to Home -> Use First Row as Headers
  • Add Column -> Index Column -> From 0

Page 220 

• The 3rd bullet should read:
  • Right-click the Attribute Value column -> replace values -> replace | with null
• Fixed in Digital Edition: TBA
• Fixed in Print Edition: TBA

Page 233

• Final bullet should read as follows:
  • “Pressing escape will dismiss the Intellisense, while typing a space, tab, or enter will accept the Intellisense suggestion”
• Fixed in Digital Edition: 2023-01
• Fixed in Print Edition: 2nd Printing

Page 238

• Final bullet should read as follows:
  • Name the column “Pays Options Dues” and use the following formula:
• Fixed in Digital Edition: 2021-11-30
• Fixed in Print Edition: 2nd Printing

Page 247 

• The last bullet should read:
  • Structured – which appears appear in a colored font font such as table, list, record and even function.  They are may be constructed from primitive values or other structured values.
• Fixed in Digital Edition: TBA
• Fixed in Print Edition: TBA

Page 348 

• The Parts bullet should read:
  • Parts – dynamically references the correct list of binary files (based on the value of the Use Buffering parameter) extracting on the Forecast Parts data from each file.
• Fixed in Digital Edition: 2021-11-30
• Fixed in Print Edition: 2nd Printing