Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Patron
Post Patron

Text changed to null by power query

Hi guys, I am debugging a report that wasnt showing comments from the source.

I narrowed it down to an anomaly in the power query.

I narrowed it down to a step in the transfomation.

the step that changers the text to a null doesnt even work on that column.

please see the screen capture.


#"Filtered Rows5" = Table.SelectRows(dbo_vw_FODSPRD_SourceFilesSLA, each ([Feed System] = "MXLN") and ([Batch Date] = #datetime(2023, 5, 16, 0, 0, 0))),
#"Renamed Columns" = Table.RenameColumns(#"Filtered Rows5",{{"Process Started", "Miles Process Started"}}),Capture1.PNGCapture2.PNG


any idea why?

Community Support
Community Support

Hi @IanCockcroft ,

Not sure why, but you can try the following to dig.

1.Delete the "Renamed Columns" step, then go to the "Filtered Rows5" step, rename column by right-clicking the "Process Started" column header again.


2.Rename other columns to see if the issue can occur also.

If all can't help, we maybe need the pbix without sensitive data to dig.


Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

@IanCockcroft If that code is taken directly from Advanced Editor that's really odd.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi Gregg, yes, its the 2 lines from the advanced editor.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors