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!

Reply
Anonymous
Not applicable

The field (column name) of the record wasn't found

The source is coming from web in csv format

 

I have tried the following steps to resolve:

- remove Column=42

- rename column headers to lower case

- duplicating column and then perform split

 

Record not found.jpg

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Removed "promote header" command and had to manually re-name all the columns but it works.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Removed "promote header" command and had to manually re-name all the columns but it works.

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

I'm afraid that the issue should be caused by the step Split columns.

From the query, it seems that the Cost_Center_-_Name wase be changed for Cost_Center_-_Name.1 and Cost_Center_-_Name .2.

After spliting columns, please click refresh and then try to apply and close.

If you still need help, could you share the query which could reproduce the issue so that I could have a test on it? 

In addition, please note do mask your sensitive data before uploading.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi Cherry,

 

The data source is web (Workday). While the downloaded csv of the same report works fine but the error results only if the same report is from web source. Unfortunately, I am unable to share the web report access. 

 

I have also tried duplicating the column and then split the duplicate column but even after that, same error exist "the table wasn't found" while I could see the same column on the file.

 

many thanks,

Manan

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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