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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

power query bug in power bi service datamart

Cannot rename columns before or after splitting

GTS2010_0-1662673890865.png

 

Status: Investigating

Hi @GTS2010 ,

 

Accordding to  your error message:

vmengzhumsft_0-1662715861645.png

It is obviously that in this table, you have a query reference to the original "PO_Number" column, and now it has been split two new columns . So for the query, the "PO_Number" column can not be found, so the error "Invalid column.." caused.

 

Therefore, you need to check your table for visual or other references to the original column, remove it and re-add the current column.

 

Best regards,

Community Support Team Selina zhu

Comments
v-mengzhu-msft
Community Support
Status changed to: Investigating

Hi @GTS2010 ,

 

Accordding to  your error message:

vmengzhumsft_0-1662715861645.png

It is obviously that in this table, you have a query reference to the original "PO_Number" column, and now it has been split two new columns . So for the query, the "PO_Number" column can not be found, so the error "Invalid column.." caused.

 

Therefore, you need to check your table for visual or other references to the original column, remove it and re-add the current column.

 

Best regards,

Community Support Team Selina zhu