Forum Discussion
Fields missing in applied steps after Power BI upgrade
Hi. After recently upgrading Power BI Desktop to v2.139.1733.0, I needed to change a data source from an Excel file to a SharePoint link. I created several calculations in the original query, so I copied a majority of the steps in Advanced Editor and applied them to the new query.
As I was reviewing each applied step, I noticed there were three missing columns. Prior to the step where the columns disappeared, I added a new column, changed its type, duplicated a date column, parsed the year, renamed the new year column, then duplicated another date column. When I duplicated the second date column, the three new columns I created in the previous steps were gone.
The original query used the same applied steps and the columns that are missing in the new query are not missing in the original query.
Has this happened to anyone else? Does anyone have a solution?
Can you verify that each step in Power Query Advanced Editor references the step name before? And that the last line (after "in") references the last step?
Sample of GOOD code:
let
Source = ... ,
StepOne = Source(... ,
StepTwo = StepOne (... ,
in
StepTwo
BAD:
let
Source = ... ,
StepOne = Source(... ,
StepTwo = StepOne (... ,
in
StepOne
1 Reply
- ToddChitt
Super User
Can you verify that each step in Power Query Advanced Editor references the step name before? And that the last line (after "in") references the last step?
Sample of GOOD code:
let
Source = ... ,
StepOne = Source(... ,
StepTwo = StepOne (... ,
in
StepTwo
BAD:
let
Source = ... ,
StepOne = Source(... ,
StepTwo = StepOne (... ,
in
StepOne