Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
benjamin_sasin
Resolver I
Resolver I

Error message covers table

Hi all,

 

I don't really understand why the UI of Power Query is throwing errors while writing an incomplete step, and covering the table with that error message.

 

I'm typing this formula, realizing I need to scroll to the right to read the exact column name, but as soon as I do that, Power Query thinks there's an error and places that error on top of the table, so I cannot read the column name.

 

There doesn't seem to be a way to dismiss this message either.

 

2019-11-22 (1).png

1 REPLY 1
stvsurf
Resolver I
Resolver I

Would be better indeed if it would be possible to scroll in the overview while editing the formula, I don't know how to prevent that.

What I usually do to replace values:

1/Go to the column where you want to change the values

2/Right click the column header > Replace values

3/ enter value to find and value to replace with

 

This way you don't have to type the exact name of the column

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.